>Hello fellow weekend-workers <g>,
>
>I am changing a candidate key on many of my tables from a single field to a composite expression (e.g. TBL_ID_FLD + BINTOC(TBL_INT_FLD)). My question is, do I also need to create a regular index on the TBL_ID_FLD in order for Rushmore to find records faster? That is, will Rushmore use the composite index key? (and if so, I can save on not having to create an extra index tag).
>
>Thank you in advance for any questions.
Hi Dmitry,
The potential problem is the following. If the key is made up of data provided by the user, you will need to filter the index on
not deleted(). Otherwise, if the user deletes the record and creates a record with the same key again, he will get an error message to the effect that the record already exists.
A filtered index can't be used for Rushmore optimization.
On the other hand, it is a little doubtul that you will do a query precisely on the expression you specified - unless you use the exact expression explicitly.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)