Subject Re: [firebird-support] Index question
Author Christian Gütter
Hello Thomas,

> Indices are your best friend if you want to get a small
> result set out of a huge table, specified by a WHERE
> clause. Using indices when the engine has to visit all
> records in a table (for example if you want all records
> back, cause you haven't specified a WHERE clause) is
> usually a bad thing, because a FULL TABLE scan is
> "cheaper" without using an index.

In this case, IBO is doing it when no search criteria are
entered. Perhaps I should forbid this in my application.

Thanks,
Christian