Thanks Brinkman..
Is there any other way?

Regards,
Siva

--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<firebird@a...> wrote:

> Hi,
>
> > How can i avoid using index in my sql?I remember i had seen one
> > message in this group once how to avoid using index in sql.Now i
> > cannot able to find out the same message.Please help me.
>
> You can avoid that the optimizer choose a INDEX by

adding/concatenating a

> value
>
> examples :
>
> if ID is datatype INT / etc..
>
> SELECT
> *
> FROM
> TableX
> WHERE
> ID + 0 = 5
>
>
> if ID is datatype VARCHAR / etc..
>
> SELECT
> *
> FROM
> TableX
> WHERE
> ID || '' = 'JOHN'
>
> The question is only if you really need this workaround!
>
> 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