What fields need to include for Indexing?

• HardCoder

  Ten Centuries

  Points: 1045

  More actions

  February 2, 2010 at 4:44 am

  #156635

  Hi all,

  I like to know what fields need to include for better performance, as per my knowledge the fileds which comes into where clause need to include in the indexing (covering index will be more good if we can use) .

  But in my case the where fields is such that like a fileld which have only two values [0,1] in that case i think this will not be a good to choose.

  So I like to know if the performance improves if we use indexing the fields which included into GROUP BY ??

  Thanks, Irfan

  Mohammad Irfan
  http://matespoint.blogspot.com
  http://www.irfit.com

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 2, 2010 at 8:47 am

  #1112326

  Here are a couple of blog posts that are good reads for selecting indexes:

  http://feedproxy.google.com/~r/SqlInTheWild/~3/Oi1xzC6jiZ0/

  http://feedproxy.google.com/~r/SqlInTheWild/~3/qNiI731n59Q/

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question