[thelist] re: query take too long
mqueme
mqueme at solucionweb.com
Fri Mar 26 07:51:44 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.
i'm using mysql, and the join isnt indexed could that help?
Marianela
More information about the thelist
mailing list