function-based index

[mirza]

How to create a function-based index on the expression?
I am using 10.2.0.4.
Please also tell that can We create the same through Enterprise manager?


Thanks in Advance

Rgds,
Mirza

[rajavu]

what kind of expression you mean ?

This link may help you.

Yes. you can create.

[mirza]

EM recommending :-

Rewrite the predicate into an equivalent form to take advantage of indices. Alternatively, create a function-based index on the expression.

The optimizer is unable to use an index if the predicate is an inequality condition or if there is an expression or an implicit data type conversion on the indexed column.

[zargon]

EM recommending :-

Rewrite the predicate into an equivalent form to take advantage of indices. Alternatively, create a function-based index on the expression.

The optimizer is unable to use an index if the predicate is an inequality condition or if there is an expression or an implicit data type conversion on the indexed column.

Which doesn't answer the question. What is this problem query? Which function are you using that causes the tuning advisor to recommend a function-based index? Creating a function-based index is easy enough:

CREATE INDEX my_fbi
 ON mytable(to_date(mydate, 'MM/DD/RRRR'))
 /

You really need to provide more information than you do so others can assist you.