Subject | Re: [ib-support] Full table scan |
---|---|
Author | Svein Erling Tysvær |
Post date | 2002-06-25T10:47:54Z |
>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