Subject Re: [ib-support] view on a table to speed up queries
Author Jan Agermose
just to be sure. What is meant by low-selectivity and does it change
(logtype, id) to (id, logtype). id being the primary key


On Mon, 2002-04-22 at 16:05, Helen Borrie wrote:

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 · ·

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to

[Non-text portions of this message have been removed]