On Tue, 23 Jul 2002, Daryl Herzmann wrote:
> Hi!
>
> Thanks for the continued help.
>
> I have attached the results of your request. Thank you!
Hmm, when the data was put in, was it put in where the same value
would be bunched up? IIRC that's a case the optimizer won't realize
if the data isn't ordered but merely bunched together that'd cause
it to over-estimate the cost of an index scan. Clustering on the index
might help, but cluster drops alot of info about the table, so you
have to be careful.