When should indexes be created?

Long Answer
Views 446

Answer:

  • 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

Related Articles:

This section is dedicated exclusively to Questions & Answers. For an in-depth exploration of SQL, click the links and dive deeper into this subject.

Go to Question List

Join Our telegram group to ask Questions

Click below button to join our groups.

Ask Question - CSE
Programming Language - PDF