Mike Yearwood
Toronto, Ontario, Canada
>>I'm not sure I ever did this much, if any, and so it's been awhile since I thought much about this, but isn't it going to cause a problem if you create an index on an integer field where the index expression is ALLTRIM(STR(INTEGER_FLD))? That's going to create a variable length index, correct? And I'm not sure why you would index such a field - which is the PK in the table in question - on anything other than just the field itself (in other words, the index expression just contains the field name).
>>
>>Russell Campbell
>
>I agree. I not sure, but I don't think such a index would aid in the rushmore optimization.
The index tag expression and the where/for clause have to match for Rushmore optimization. It's control over the length of the index expression that's important here.
So you INDEX ON PADL(ALLTRIM(STR(INTEGER_FLD)),10,'0') and you SELECT BLAH WHERE PADL(ALLTRIM(STR(INTEGER_FLD)),10,'0') = "0000000001" and it'll be fine.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only