Subject Re: [ib-support] Full table scan
Author Svein Erling Tysvær
>How can I force Interbase to avoid using the index when I do a 'select *' ?

If you have no where or join clause no index will be used. If it is in a
where clause I normally "or" it with something false making it useless, e.g.

SELECT *
FROM SWEDEN
WHERE (NAME = 'MAGNUS' or 1=0)

HTH,
Set