Hi,

> there is index on "Booking"."End Date" and
> "Booking"."St Date"
>
> if i remove the index its working fast. both the
> client and booking table has more that 300,000
> records.
>
> plan Analyzer says that this query uses "Booking"."End
> Date" & "Booking"."Client No" indices and NOT
> "Booking"."St Date" index.
>
> how do i make it work fast with index.

Did you read my previous reply in this thread ?

You can see it also on the atkin newsserver
news://news.atkin.com/egroups.ib-support

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81