Examine the output of the query executed to diagnose the reason for performance degradation of queries:

Which three factors will you investigate further to identify the cause of the performance degradation? (Choose three.)

Select all that apply.

• A

  Check the number of disk sorts.

• B

  Check for the causes of the full table scans.

• C

  Check the number of chained or migrated rows.

• D

  Check the indexes on the tables used in queries for clustering factor.

• E

  Check the size of the temporary tablespace for sorting operations.