The guy created a third column and added column 1 and column 2.

By using the third column, he found a considerable performance boast
versus using indexes on Column 1 and 2, or a combination index
that included both.

Ivan Prenosil wrote:

>>I our current project I could increase the speed by about 500 times for
>>retrieving rows by doing the following:
>>
>>
>
>Such message is useless if it does not say what exactly was done,
>what were the plans before and after change etc.
>
>Ivan
>http://www.volny.cz/iprenosil/interbase
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

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

http://www.bss-software.com



[Non-text portions of this message have been removed]