Subject Indexes - Ques for both IB and FB
Author Thomas Miller
Anyone have some good general info on how both or either uses indexes
for optimization?

Things specifically I have questions about

Is it faster to have complex (multi-column) indexes then multiple single
column indexes?

Will the DB use the first column on a complex column index if it
matches, or do I need a separate index?

INDEX_1(columnA, columnB, columnC)

select * from MYTABLE
order by columnA

Will this use the index? How about joining tables? Thanks.

Thomas Miller
Chrome Portal Project Manager
CPCUG Programmers SIG Chairperson (formally Delphi)
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork