Subject | RE: [firebird-support] Query Performance - correlated subqueries and group by statements |
---|---|
Author | Leyne, Sean |
Post date | 2005-04-14T20:49:37Z |
> However, Firebird indexes do suffer when there are large (> 10,000)For the info of other list members (Ann already knows this), Firebird
> numbers of instances of a single value in an index. Check the list
> archives for discussions (many many discussions) of index selectivity.
v2.0 has new disk structure for indexes which significantly (incredibly)
improves the engines performance when handling low selectivity indexes.
Sean