This content has been marked as final. Show 3 replies
For better performance when using FILTER involving regular expression, you may want to create a full-text index on MDSYS.RDF_VALUE$ table as described in:
I am assuming that you are checking for case-insensitive occurrence of the string GB035698 in ?x or ?y. (On the other hand if you are checking if ?x or ?y is equal to a case-insensitive form of the string GB035698, then the filter could be written in an expanded form involving just value-equality checks and would not need a full-text index for performance.)
yes I am checking case insensitive test occurance in the x or y. Any other suggestions?
Assuming your value filter is the most selective part, use of a full-text index would be the best option. Thanks.