Hi Gail,

As you can see in the Execution plan a large amount about 46% is being consumed by Hash joins.

I am not sure if I want Nested loop joins or...

I am not sure why this particular date is showing up in Aruguments getdate()-'sep 28 1902 12:00 AM.

I havent included this date in any of my where clauses.

My question is...

I could convert all my table scans into Index seek by including the columns the query returns.

I still have one question:

Though the recent data in my table is from 2005,...

Hi Gail,

Thanks for your response. It is true that my select statement has more columns, may be that is the reason why table scan is going on. Do you...