| 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.
| Thread | ||
|---|---|---|
| • How to optimize this | Goran Krajacic | 28 Dec |
| • example scripts | Bobby Brooks | 28 Dec |
| • Re: example scripts | Bogdan Stancescu | 29 Dec |
| • Re: How to optimize this | Dan Nelson | 28 Dec |