>If I understand your question.....
>
>You can redirect the results of the view into a table like this...
>
>Select * into #Temp from vwSalesResults
>
>Obviously, that won't solve the original problem.
>
>I have a couple of theories on what the problem might be, but would like to see the 2 execution plans and information about the tables.
>
>One question to ask for right now - how often are the indexes on the tables recreated, and how often are the statistics on the tables updated? (i.e. is there an overnight job to reindex, update statistics, etc.)
Here's a WAG first reaction on my part : I would be curious to know more about the HeadOffideCode colum - data type and contents. (and of course the exact indexes) For example, is there only AAA but might be BBB, BB1, BBB2.
Would this make a difference?
And what would be the difference if he used Where HeadofficeCode like 'BBB%'
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.