Re: what is invisible in indexes in Oracle ?
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 11 Nov 2013 00:13:29 +0000 (UTC)
Message-ID: <pan.2013.11.11.00.13.29_at_gmail.com>
Date: Mon, 11 Nov 2013 00:13:29 +0000 (UTC)
Message-ID: <pan.2013.11.11.00.13.29_at_gmail.com>
On Sun, 10 Nov 2013 14:58:52 -0800, dbaonline99 wrote:
> hello guys, am learning Oracle so I need help understanding invisible
> indexes.
Indexes can be made invisible to the optimizer for the testing purposes. The idea is to create an index enable the optimizer to use the invisible index for your session and test without affecting the other users. The technicalities can be found here:
http://www.oracle-base.com/articles/11g/invisible-indexes-11gr1.php
-- Mladen Gogala The Oracle Whisperer http://mgogala.byethost5.comReceived on Mon Nov 11 2013 - 01:13:29 CET