More or less SARGABLE clauses in a WHERE Clause

• Rob Reid-246754

  SSCarpal Tunnel

  Points: 4183

  More actions

  November 29, 2012 at 5:10 am

  #1563682

  Hi the source of my data is from a feed which lists out the courses and the races on each course that day.

  There is no human input involved - all automated.

  If I had to choose a natural key it would be

  CourseFK, RaceName, RaceDatetime, RaceType

  And as I have said before RaceName can have anything up to 255 characters in it which would make for a wide index.

  Thanks