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@...> 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