Re: speed up select distinct

Tomislav Kokoska wrote:

> What is the best way to speed up query looks like:
>
> SELECT DISTINCT COLUMN1, COLUMN2, COLUMN3, COLUMN4 FROM TABLE WHERE COLUMN5
> = 5

Depends on the cardinality of the COLUMN5 and what percentage of the rows are returned by the query. When you provide that information also provide the complete version number.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)