Hi,

As a point of reference, I have an extremely strong background in Oracle
(and the way Oracle Indexes work).

Compound or Complex Indexes (indexes with more then one column)

With Oracle it is recommend to use these. Years ago, I was told not to
use them for
IB. That I should just index each column individually and the optimizer
would
do the rest. These indexes are primarily used for complex joins between
multiple tables. So which is the best way for FB

a) Multiple single column indexes
b) One multi-column index

Is it different when primarily using the index to speed up sorts / searches?

Thanks in advance.

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus