Hi,

> >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
reads
and narrowing down any results from the index... Isn't this right?


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

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