✏️ Explanatory Question

What is Index Analysis used for?

👁 12 Views
📘 Detailed Answer
🟡 Medium
← Previous What information does the Performance Metrics tab provide?
💡

Answer with Explanation

Index Analysis helps identify:

  • Index usage patterns

  • Scan vs seek behavior

  • Update frequency

  • Row counts

This assists in deciding whether to add, drop, or rebuild indexes.

← Previous What information does the Performance Metrics tab provide?