List:General Discussion« Previous MessageNext Message »
From:Goran Krajacic Date:December 28 2001 9:39pm
Subject:How to optimize this
View as plain text  
How to optimize this query:

SELECT col1, col2, MAX(col3) FROM Table WHERE col4>2 AND col5 = 2 GROUP BY
col3 LIMIT 1;

The best that i figured out is to set the index on col3.
I was unable to find out the working combination for multi-column indexing.
Please advice.

How to optimize thisGoran Krajacic28 Dec
  • example scriptsBobby Brooks28 Dec
    • Re: example scriptsBogdan Stancescu29 Dec
  • Re: How to optimize thisDan Nelson28 Dec