New Optimizer Feature with 11g (1) Invisible indexes With an 11g release, the index can be made invisible. They will be maintained all the time and can be made visible at any time alter index K invisible; Optimizer will not use the index if it is invisible alter index K visible; If want one query …
New Optimizer Feature with 11g,12c and 19c Read More »
The post New Optimizer Feature with 11g,12c and 19c appeared first on Techgoeasy.
This post first appeared on Techgoeasy - Learn Oracle, PHP, HTML,CSS,Perl,UNIX, please read the originial post: here