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