>>The table has 10 million rows. The query is
>>select top 1000 * from sales where date > '1/27/2003'
>>and week_calculated = 0
Things to check
1. Do you have a clustered index ?
2. Do you have an index on that date field ?
You can always text the query in query analyzer and do a show plan on the query.
Do the following
1. Select you database in the Query Analyzer
2. Run the following in the query analyzer
SET SHOWPLAN_ALL ON
go
select top 1000 * from sales where date > '1/27/2003'
and week_calculated = 0
go
Post the text results here and we'll take a look at the problem.
Rodman
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.