Subject Re: [ib-support] view on a table to speed up queries
Author Helen Borrie
At 03:24 PM 22-04-02 +0200, Svein wrote:
> >does multicolumn indexes make sense if you use them in a non multicolumn
> >query?
>Yes, because duplicates in an index make things slow down. When running the
>query, IB will only use those parts of the index that are useful.

Actually, you must define this index with the low-selectivity column first,
followed by the unique id in second spot.


All for Open and Open for All
Firebird Open SQL Database · ·