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,