Updated and latest Oracle 1Z0-060 dumps exam practice questions and answers, pass Oracle 1Z0-060 exam test quickly and easily at first attempt. https://www.leads4pass.com/1z0-060.html dumps pdf questions and answers. Download free 1z0-060 test answers for VCE Exam, one of the many PDF readers that are available for free.
QUESTION 1
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions. The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. 1Z0-060 pdf
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rowsare returned.