New Optimizer Feature with 11g,12c and 19c

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 »