Best practice for creating indexes

• Edmond Shamon Larson

  SSC Enthusiast

  Points: 103

  More actions

  January 5, 2006 at 12:14 pm

  #166672

  What are a few best practices for creating indexes on a table?

  For example, I have three tables.

  Table 1 (employee info)

  --------------

  Emp_ID - PK

  First_Name

  Last_Name

  Table 2 (school info)

  --------------

  id - PK

  Empl_ID - Foreign Key

  School_Type_ID - Foreign Key

  School_Name

  Degree_Received

  Table 3 (category info - includes school types and other types)

  --------------

  id - PK

  Type_ID - Foreign Key

  Type_Name

   

  ---

  Thanks,

  Edmond Shamon Larson
  

• peterhe

  SSChampion

  Points: 11469

  More actions

  January 5, 2006 at 1:17 pm

  #613028

  generally speaking, you should create indexes on FK columns, e.g. create an index on Emp_ID column in Table 2

• Edmond Shamon Larson

  SSC Enthusiast

  Points: 103

  More actions

  January 6, 2006 at 7:25 am

  #613217

  Thank you. I'll do that.

  If there's any additional suggestions please feel free to post.

  ---

  Thanks,

  Edmond Shamon Larson