Hello,
I have a problem with regards to a function based index.
example:
TableName: Test
Column : A, B, C, D
I create the index on table test, column A using a user defined function.
if i make a select on the column, it will be okay. That is, i will get the wanted result.
However, if i insert into the table and commit, and i make a query using column 'A' in the where clause. I dont have any query hits. Its really weird.
Have you ever experienced this problem? and are there any dos and donts w.r.t function based index?
Thank you.
MichaelR