Subject | Re: [ib-support] Plan not working |
---|---|
Author | Nando Dessena |
Post date | 2001-11-05T12:10:33Z |
Ann,
Whether using the index is always faster or not, I don't know (neither
do I imagine how can possibly the optimizer figure it out, but it has
the stats after all).
Ciao
--
____
_/\/ando
> >Whoops; in fact it should. I was confusing with a similar (but notI was referring to the current situation, not the ideal one.
> >exactly equivalent) setup I had tested here.
>
> In fact, it shouldn't, unless we get some timing tests that
> suggest that using the index is faster.
Whether using the index is always faster or not, I don't know (neither
do I imagine how can possibly the optimizer figure it out, but it has
the stats after all).
Ciao
--
____
_/\/ando