DS0-001: CompTIA DataSys+Demo

By CompTIA · Question Mode

QuestionQ109

Database Management and Maintenance

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

  • A Missing indexes
  • B Code
  • C Table integrity
  • D Database patches
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!