-
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
-
function based index - oracle internals
Any thoughts??? Nobody seem to have any answer. Lots of people seem to have viewed...
-
so what?
since you have noticed people looked the post why you spam?
-
Re: function based index - oracle internals
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
Reddy,Sam
-
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).
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|