Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Statement resources are spent performing Range index scans on the index specified in the Object column.
| Heavy Index Range Scan finding |
| Description | |
| What to do next | Perform one of the following options: n Click the Locate icon to focus on the relevant step in the execution plan. n Select the finding type to investigate the objects used and their structure in the Objects tab. n Select the finding type to investigate step statistics and resource consumption in the Statistics tab. |
| Advice | To reduce the Range Scan resource consumption consider: n Checking the matching level of the Index to discover if there is a mismatch between existing Where predicates and operators with column order in the Index. n Changing column order in the Index for better matching level or adding a new index. Check the global effect of this change by launching to WhatIF workspace. |
No comments:
Post a Comment