Tutorial Flow:




Performing a detailed diagnosis


Recall that the database administrator has localized the slowdown is in SQL statement processing. A common approach is to explain the SQL statement and analyze the access plan. The database administrator looks at the monitoring report generated to get a quick, initial indication of why the statements are so expensive.

Few monitor elements useful for analyzing expensive access plan operations



The evidence suggests that the slow statements are scanning table rows rather than using an index, because no suitable index is available.