Hi to all
I've created an index based on a UserDefinedFunction, index is like this:
fnMyFunction(fieldToIndex)
I do a SELECT SQL like this:
SELECT * FROM myTable WHERE fnMyFunction(fieldToIndex) = fnMyFunction(keyToSearch)
Is this query Rushmore optimizable ?
PS: I try with SYS(3054,1) and I've optimization level = none
but on a whitepaper I've found that index based on a Udf is optimizable.
SET OPTIMIZE is ON
Thanks in advance,
Renato