You observed in your database that the queries formerly executed in 5 seconds now take longer time.View the Exhibit and
Posted: Sun Jun 11, 2023 3:50 pm
You observed in your database that the queries formerly executed in 5 seconds now take longer time.View the Exhibit and analyze the output of the query that you executed to find the problem.Which is the primary concern?
A. the number of disk sorts
B. the number of full table scans
C. the number of chained and migrated rows
D. the number of rows fetched based on rowid
- You Observed In 1 (86.94 KiB) Viewed 260 times
B. the number of full table scans
C. the number of chained and migrated rows
D. the number of rows fetched based on rowid