Using the Plan clause together your select. For a example:

select no_client, name from table_client
where (no_client = 5)
plan (table_client index(no_client_idx))

Use this clause with care, many times is better let the optimizer choose the
plan. Optimizer knows selectivity question in the real time that you can�t
consider in the design time.

Look for a complete Plan's explanation inside Interbase help Docs.

regards
danny



""semprolbat"" <semprolbat@...> escribi� en el mensaje
news:af9ddq+kkah@......

> I have a table with 300K+ records that has an index.
> How can I force Interbase to avoid using the index when I do
> a 'select *' ?
>
>
> Magnus
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>