Re: distinct too slow

2 options...

1. Don't use it!
2. If you don't have an index on the column you are running the distinct on, consider adding one.

Distinct is not very efficient. You may want to consider other methods to do what you are doing... but since you don't say why you are using distinct, I can't make any suggestions Received on Fri Feb 16 2001 - 04:43:53 CST