QuestionQ109

VerifiedDatabase Management and Maintenance

A database analyst observes that a query statement is executing slowly. Which of the following should the analyst examine first?

Explanation

Missing or inappropriate indexes can force a query to scan far more rows than necessary instead of using an efficient access path. Index availability and suitability should therefore be reviewed first when diagnosing a slow query.

Community Discussion

No comments yet. Be the first to start the discussion!