function based index - oracle internals
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: function based index - oracle internals

  1. #1
    Join Date
    Jan 2001
    Posts
    28
    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

  2. #2
    Join Date
    Jan 2001
    Posts
    28

    function based index - oracle internals

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

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    so what?
    since you have noticed people looked the post why you spam?

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    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

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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
  •  



Click Here to Expand Forum to Full Width