Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Function-based index on DML-active tables

Function-based index on DML-active tables

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Wed, 5 Apr 2006 14:48:34 -0400
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C003217BAE@usa0300ms03.na.xerox.net> 





Folks,


I am trying to understand the impact of creating a function-based index
on an order entry table which is heavily used by DML statements. Can
anyone tell me the downside of creating such an index?



Any help will be appreciated.


Thanks


Amir


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Apr 05 2006 - 13:48:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US