Jeff Moden (1/22/2010)
If I understand correctly, that may be the problem... no indexes on the columns you're working with.If you could gen and capture an actual execution plan, I'm sure someone here would be able to make a better recommendation as to what your plight may be.
Many people here are very good with execution plans. It is likely due to the indexes as Jeff has said.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events