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 I/O is spent on sequential I/O (usually representing table access by rowid following an index range scan) on the table specified in the Object column.
| Description | |
| What to do next | Perform one of the following options: n Click the Locate icon to find the relevant step in the execution plan. n Select the findings type to investigate the objects used and their structure in the Objects tab. n Select the Activity workspace, locate the statement associated with objects, and drill to the table consumption for the statement in the Activity workspace. |
| Advice | To reduce the I/O consumption for the table, consider the following solutions: n Change the index structure by adding a better filtering column, or change the column sequence to improve the matching and screening performed in the index tree. n Add columns to the index to enable index only access. n Switch to a full table scan. n Partition the table or the index. n Create a cluster with just one table in it and a cluster key used as the index key. Findings refer to the whole statement - not to a specific execution plan. If a step doesn't exist in the selected execution plan (unless this is the result of an index overhead), switch to another plan and locate the relevant step. |
No comments:
Post a Comment