>
>>I understand that I would have to be careful composing scope clauses, etc., in order for RUSHMORE to kick in and use that compound index...
>
>Yes, you have to match on the left of the "=" sign the index tag exactly. So if in a SQL statement you have:
>
>... WHERE STR(id)+charfield+DTOS(datefield)="1234567890TEXT20010208"
>
>
>Note that if you are only trying to match leading parts of the key, you still need to specify the entire key on the left side:
>
>... WHERE STR(id)+charfield+DTOS(datefield)="1234567890"
>
>If you don't match the key in it's entirety, Rushmore will not kick in.
That was my understanding. Thanks Fred. This just means composing some interesting looking WHERE clauses, and such.. I've been working on a redesigned database structure lately, and I'd like to try and design indexes and the various pieces of code that use them to be as efficient as possible.
Jim Newsom
IT Director, ICG Inc.