Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!85.12.40.131.MISMATCH!xlned.com!feeder3.xlned.com!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: what is invisible in indexes in Oracle ? Date: Mon, 11 Nov 2013 00:13:29 +0000 (UTC) Organization: A noiseless patient Spider Lines: 18 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Injection-Date: Mon, 11 Nov 2013 00:13:29 +0000 (UTC) Injection-Info: mx05.eternal-september.org; posting-host="e4f8def8fb90dfd954091bdd9211c78d"; logging-data="27226"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19LLFbDiLj6egp+6Xh6IvYp" User-Agent: Pan/0.139 (Sexual Chocolate; GIT bf56508 git://git.gnome.org/pan2) Cancel-Lock: sha1:o/k9xXVwmf6ogReQCLASlYKd2/s= Xref: news.cambrium.nl 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.com