Subject | Re: [ib-support] Adding index does nothing to select disctinct |
---|---|
Author | Mark Patterson |
Post date | 2002-09-13T00:39:24Z |
Svein Erling Tysvaer wrote:
advantage of indexes. Maybe that can be an enhancement for version 2.0.
Thanks for the explanation,
Mark
> Hi Mark!OK, what you're saying is that SELECT DISTINCT doesn't know how to take
> 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
advantage of indexes. Maybe that can be an enhancement for version 2.0.
Thanks for the explanation,
Mark