Re: distinct too slow

If this is a multi table join, you might try using hints.

With the distinct clause, a "RULE" hint often works. Note the word often in the previous sentence. I generally discourage the use of the RULE hint, however, it may help with this query.

I quite often use the rule hint to determine if there are appropriate indexes.
If rule doesn't use them, then I ask why the indexes aren't there or, is there
a missing join?

Either way, the index mentioned by someone else was a good idea ...

jkl wrote:

> How can I speedup a query that uses distinct?
> Tanks.
Received on Sun Feb 18 2001 - 19:20:18 CST