Subject Re: [ib-support] Re: Indexs!
Author Ann W. Harrison
At 08:21 PM 9/30/2002 +0200, Aage Johansen wrote:
>I've just "stolen" the following comment in a message today on b.p.i.sql:
>I our current project I could increase the speed by about 500 times for
>retrieving rows by doing the following:
>I defined an additional field which contains the values of the both columns
>in question stripped together by a trigger and defined a no compound index
>on that single column instead of the compound index on the both columns.

OK, time for some actual tests. Theoretically that guy is all wet.
But that raises the old question: "What's the difference between
theory and practice?" And the answer: "In theory, nothing."


We have answers.