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
Index is extensively accessed via fast full index scans.
| Description | |
| What to do next | Perform the following: n Examine associated statements in the Statements tab. n Focus on the Fast Full Index Scan access type in the Access Types table. n Examine column usage for each statement in the Columns table. |
| Advice | Perform one of the following options: n Fast Full index scan can be eliminated by: Identifying common high selectivity columns for the top statements. Create an index matching the statements predicates. Partitioning the table according to the best predicates existing in the statements. n Fast Full Index scan can be improved by: Moving the index to another space with a higher block size. Increasing the DB_FILE_MULTIBLOCK_READ_COUNT init.ora parameter. |
No comments:
Post a Comment