I'm trying to test the expression filters functionality using two tables:
Env: Oracle 11g R2 (220.127.116.11) EE on AIX
T1 is the data table and contains about 90 million rows with around 60 columns. Only 4 columns are evaluated in the filter with three of them always having a value (me_cat, me_tp, me_code) and the other one (base_plan) having nulls in some rows.
T2 contains 666 expressions using the four columns I mentioned before in every expression.
I have tried different parameters for the index on the T2(expression column) but it doesn't help at all.