[thelist] query takes too long

Paul Cowan evolt at funkwit.com
Thu Mar 25 21:57:56 CST 2004


On 25/03/2004 2:45 PM -0600 mqueme wrote:
> I have this query that takes way too long How can i improve its
> performance?

1) What database server are you using?
2) Have you looked at the indexing on the tables in question? How much
   data is in each?
3) What does the query plan look like? (In MS SQL Server, run
   SET SHOWPLAN_ALL ON, and then run your query). This will often
   show where the problem is (look in the EstimateCPU as a good starting
   place, as well as TotalSubtreeCost)

SQL Server Query optimization for dummies, chapter 1: if you see
a "Table Scan" in your query plan, and the table involved has a lot of
rows, you may well be just one well-thought-out index away from making
your query perform well.

Cheers,

Paul.


More information about the thelist mailing list