Hi All,
I have created a function based composite index using substr function. The query doesn't use the index. I am not sure wether substr can be used in a function based index and can a function based index be composite ??
I would really appreciate your help.
Thanks,