Subject | Re: [firebird-support] Index question |
---|---|
Author | Christian Gütter |
Post date | 2003-11-26T23:45:41Z |
Hello Thomas,
entered. Perhaps I should forbid this in my application.
Thanks,
Christian
> Indices are your best friend if you want to get a smallIn this case, IBO is doing it when no search criteria are
> 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.
entered. Perhaps I should forbid this in my application.
Thanks,
Christian