What is a covering index and when should you create one?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What is a covering index and when should you create one?

Key points

  • Covering index includes all query columns
  • Improves query performance by avoiding key lookups
  • Created for queries with frequent performance issues

Ready to go further?

Start full exam Practice more questions

Related questions