✏️ Explanatory Question

When should indexes be created?

👁 446 Views
📘 Detailed Answer
← Previous When should indexes be avoided?
No next question
💡

Answer with Explanation

  • A column contains a wide range of values
  • A column does not contain a large number of null values
  • One or more columns are frequently used together in a where clause or a join condition
← Previous When should indexes be avoided?
No next question