function based index - oracle internals

[padma]

Hi,

Can somebody tell me if Oracle maintains 2 indexes if I create a function-based index (one normal and another one with the translation) ? Also, if I have function based index on a table, does it affect the performance of insert, update and delete on the table?

I can't find any document regarding the performance or oracle maintaining 2 indexes internally. But one of the DBAs suggest that it is the case and asking us to create an additional column with the upper(column) and use a normal index.

Any suggestions / thoughts are welcome.

Thanks

[padma]

Any thoughts??? Nobody seem to have any answer. Lots of people seem to have viewed...

[pando]

so what?
since you have noticed people looked the post why you spam?

[sreddy]

Originally posted by padma
Any thoughts??? Nobody seem to have any answer

Sometimes that says: The question is not clear...
See these links might help...

http://www.embarcadero.com/news/functionindex81.asp
http://www.dbasupport.com/oracle/ora8/fbi.shtml

[jmodic]

If you create function-based index, oracle will act exactly the same as with any "normal" index - there will be no two sepparated indexes to support a single function based index, there is absolutely no need for oracle to do this internaly. And the internal structure of that function-based index will be the same as with any other B*Tree index.

And yes, of course function-based index will have an effect on inserts, updates or deletes, just like any other B*Tree index does (well, function-based index will have a slightly higher owerhead actually).