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.

Back in the 5.x days of IB, I was told never to create indecies made up
of multiple
columns. Is that still true? Any other insights would also be welcome.

When I create a primary key, the engine makes two indexes. One as a primary
key and one that it not. They both are indecies of the primary key. Is
this a bug?

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

http://www.bss-software.com