1Z0-117 | The Refresh Guide To 1Z0-117 examcollection
splitQ1. What are three common reasons for SQL statements to perform poorly? A. Full table scans for queries with highly selective filters B. Stale or missing optimizer statistics C. Histograms not existing on columns with evenly distributed data D. High index clustering factor E. OPTIMIZER_MODE parameter set to ALL_ROWS for DSS workload Answer: A,B,D Explanation: D: The clustering_factor