0
An invisible index is maintained for any DML operation but is not used by the optimizer unless you explicitly specify the index with a hint.
Applications often have to be modified without being able to bring the complete application offline. Create invisible indexes temporarily for specialized non-standard operations, such as online application upgrades, without affecting the behavior of any existing application. Furthermore, invisible indexes can be used to test the removal of an index without dropping it right away, thus enabling a grace period for testing in production environments.
- From Oracle 11g Database New Features manual
What else can I help you with?
Oracle latest version?
Oracle 11i Oracle 11i
Who needs to get oracle 11g certification?
The oracle 11g certification is for those who plan to use and or teach oracle 11g programs. They must go through the training process in order to fully be able to teach it.
Which oracle version is compatible with Windows 7?
Oracle 11g R2
In oracle 11g what is g mean?
grams
What is Oracle 11g and what are some new features of Oracle 11g?
Orable 11g is a database. There are new features for DBA's and Developers. A new feature would be simple_integer, a new data type said to be faster than pls_integer.
What is feature in latest version of Oracle 11g?
I want the latest featurea in oracle 12c
What is the latesat version of oracle?
11g Release 2
What should be the next generation of oracle after 11G?
r12
What is the meaning of g in oracle 10g?
G signifies "Grid Computing"... With the release of Oracle 10g in 2003, Oracle changed the suffix in their previous release version; from 9i to 10g... 'I' stands for Internet...this was done as a marketing effort in order to show Oracle's move towards Grid Computing... Purely a marketing strategy...
Oracle Database 11g is an example of which type of database?
multidimensional database
What equipment do I need for the oracle 11G certification?
The oracle 11G certification can be one of the most difficult certifications in order to get. The only thing that would be needed to pass this test is to make sure to bring your laptop.
What does g represent in oracle 11g?
In oracle 10g or 11g, 'g' represents grid computing. Which enables clusters of low-cost, industry standard servers to be treated as a single unit. BY Er. Gurinder Singh
