Gather Column (Histogram) Stats can use an Index

(Hemant K Chitale) We use the METHOD_OPT parameter to specify columns where we want specific Histograms when running a GATHER_TABLE_STATS. Oracle can actually make use of an Index to gather such column statistics.

Read More - Register for Free Membership