Best Index Strategie...

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  October 10, 2013 at 4:16 am

  #277899

  Is it correct if I use a composite noneclusterdindex like this:

  FirstName + LastName + BirthDate

  i doen't need another index like this. The first index is enough?

  First Name + Last Name

  First Name

  or it has huge advantages for the performance?

  Best Regards

  Nicole 😉

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  October 10, 2013 at 5:44 am

  #1657462

  The first index is enough, if your queries search on first name and last name or just on first name.

  If you have queries searching on last name then none of the indexes above will help.

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]