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

Home -> Community -> Usenet -> c.d.o.server -> Re: disabled function-based index

Re: disabled function-based index

From: chao_ping <zhuchao_at_gmail.com>
Date: 8 Oct 2005 23:35:55 -0700
Message-ID: <1128839755.137573.314650@o13g2000cwo.googlegroups.com>


He simply ask a simple question, function index's status. Just check DBA_INDEXES.FUNCIDX_STATUS.

Maybe somebody did alter index disable, if he is hitting error, or used rbo or some other reason, his index is not being used, and he thought it was disabled. Received on Sun Oct 09 2005 - 01:35:55 CDT

Original text of this message

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