when to create a virutal ilndex
- From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 12 Dec 2005 08:42:28 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
