| Subject | Re: Slow query (unindexed reads) |
|---|---|
| Author | kerryneighbour |
| Post date | 2011-06-22T21:20:03Z |
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:
>The SYSCTBL table usually only has 1 record in it. At most, 4 or 5. ALL of my join fields are indexed.
> I've no idea why SYSCTBL doesn't use an index. Is it a very small table (if so, it is OK), or isn't SYSCTBL.SYSC_NUMBER indexed or with lousy selectivity?