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."


Regards,

Ann
www.ibphoenix.com
We have answers.