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: Alter index enable would be nice

Re: Alter index enable would be nice

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 04 Jul 1998 07:17:20 GMT
Message-ID: <01bda71b$4e1de6e0$0300a8c0@WORKSTATION> 






Steve,



Have you had a look at 'alter index unusable;' in 8.0.4
You may be able to take advantage of this is some way.



There would probably be problems if a plan indicated
the need for the index though then found it unusable
at run time.  Extra use of hints may bypass this.



Jonathan Lewis


Received on Sat Jul 04 1998 - 02:17:20 CDT












Original text of this message













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