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: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 14 Oct 2005 00:23:47 -0700
Message-ID: <1129274614.542217@yasure>


niy38_at_hotmail.com wrote:
> if every time a function is compiled, the index will be disabled,
> seems too fragile.

If one compiles things in a production environment more than once what is fragile is not function based indexes ... it is the DBA's skill set.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Oct 14 2005 - 02:23:47 CDT

Original text of this message

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