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

http://www.bss-software.com
http://programmers.cpcug.org/
http://sourceforge.net/projects/chromeportal/
http://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus