Paste the query into Query Analyzer and view the Estimated Execution Plan. This will show you an estimation of how SQL Server would execute the query. The percentage values will show you which steps are hurting your performance.

There are a few things that comes to mind right off hand.

1. The statistics may be corrupted or missing.
2. There may places where you need a composite index rather than a single index for each field.
3. It might still be using the old cached execution plan, and it is no longer the best way to execute the query. (Use DBCC DROPCLEANBUFFERS)

You may want to consider running the Index Tuning Wizard if you are not that familiar with indexing. I prefer to do it myself, but the wizard can be helpful.

Robert Davis
<mailto:[Email address protected]

________________________________

From: Noble Mudenha [mailto:mssqldba-ezmlmshield-x70273157.[Email address protected]
Sent: Fri 1/27/2006 1:08 AM
To: LazyDBA Discussion
Subject: Another Performance Issue



Hi guys, suppose I had a transactions table that was taking a LONG time to
retrieve data from, especially when filtered. It is indexed on all columns
where criteria to filter is specified. I reindexed (DBCC REINDEX) the table,
and now it runs slower than before, fillfactor was left unchanged. What went
wrong, if anything, and what can I do to make it faster?





---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page