Subject Re: [ib-support] Indexs!
Author Martijn Tonies

> >We currently write our software for Oracle and I am very familiar with
> >how Oracle uses indecies for speed. We are currently converting our
> >software to
> >also run on FB.
> Great! One step in the right direction.
> >Back in the 5.x days of IB, I was told never to create indecies made up
> >of multiple columns. Is that still true?
> Never was. When you create multi-segment indexes, you should put the
> least selective column(s) first, and the most selective last. That
> will help compression, thus reduce the size of the index.

Question: I tend to put the _most_ selective first to reduce index page
and narrowing down any results from the index... Isn't this right?

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase

Firebird Workbench - the developer tool for Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."