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 performanceChristopher R. Jones27 Apr
  • Re: SELECT DISTINCT performancesinisa27 Apr