4 Conditions to Select a Column for Index

The below are best 4 tips in selecting a column to create index.

  1. When the column is foreign key
  2. When the column is frequently used in search conditions
  3. When the column contains large number of distinct values
  4. When the column is updated infrequently

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.