It may return up to 250,000+ records. How given index can become "bad"?

On Sat, Feb 16, 2008 at 3:22 AM, Alexandre Benson Smith <
iblist@...> wrote:

> Deian Popov wrote:
> > I can provide the plan output Monday next week. I can explain approx.
> table
> > structure:
> >
> > id : int PK
> > col1 varchar(12)
> > impdate DATE
> > some other cols (no blobs)
> >
> > I have index on impdate(it's not unique). If I call SELECT ... FROM ....
> > WHERE impdate=<somedate> it may take up to 8 seconds to fetch the
> records
> > for that specific period. I'm sure it uses the index.
> >
> > On Fri, Feb 15, 2008 at 4:58 PM, Alexandre Benson Smith <
> > iblist@... <iblist%40thorsoftware.com.br>> wrote:
> >
>
> How many rows it returns ?
>
> Perhaps a too bad index ?
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>
>
>

[Non-text portions of this message have been removed]