when to create a virutal ilndex

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Mon, 12 Dec 2005 08:42:28 -0400
Message-ID: <cd4305c10512120442w42425591j3dac49bb52da6df6@mail.gmail.com>

Hi reading oracle insight from oak table I found the existence of virtual indexes, and on metalink I found the existence of a Create Virtual Index Wizard.

Could some one please clarify how it is used?, I supposed in big databases, when some x$ queries becomes slower, they can create virtual indexes, and this should be a very rare practices.

Thank you.

--

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 12 2005 - 06:42:34 CST