Subject Re: [ib-support] Adding index does nothing to select disctinct
Author Mark Patterson
Svein Erling Tysvaer wrote:
> Hi Mark!

> Yes, most likely. At least I cannot see anything you write here that should
> influence the speed very much. What is your WHERE clause like? If you add

OK, what you're saying is that SELECT DISTINCT doesn't know how to take
advantage of indexes. Maybe that can be an enhancement for version 2.0.

Thanks for the explanation,

Mark