""Sandeep"" <sandeep@...> wrote in message
news:3BCDBAEB.11694.1D0A61A@localhost...

> I have following statement
>
> and when I add plan
>
> *plan join (bil natural, cln index ("Cln_By_Number"), bli index
> ("Bli_By_Inv_Number"))*/
>
> to it i get error saying Index "Cln_By_Number" doesn't exists for
> table "Client_Main". I've tried using it without quotes (I'm using
> dialect 3).
>
> and when i execute it without plan the plan shown in Ibconsole is
> as
> PLAN JOIN (BIL NATURAL,CLN INDEX (Cln_By_Number),BLI
> INDEX (Bli_By_Inv_Number))

I see you created a case-sensitive index name using dialect 3. Do you really
need such names? Are you using IB? IB uppercases index names always due to
an oversight. I fixed it in Firebird long time ago.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing