| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Christopher R. Jones | Date: | April 27 2000 6:46pm |
| Subject: | SELECT DISTINCT performance | ||
| View as plain text | |||
Do indices help with SELECT DISTINCT queries with no WHERE clause? For example SELECT DISTINCT col1, col2 ORDER BY col1; Would an index on col1 help? Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-3044 Email cj@stripped
| Thread | ||
|---|---|---|
| • SELECT DISTINCT performance | Christopher R. Jones | 27 Apr |
| • Re: SELECT DISTINCT performance | sinisa | 27 Apr |