 <p>try putting a clustered index on the view. that will make the view persisted to disk like a normal table and your tables won't have to be accessed every time.</p> <p>that should speed things up a bit.</p> <p>for better answer please post the link to your original question to see if a better solution can be found.</p>