Post reply

More or less SARGABLE clauses in a WHERE Clause

  • 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

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply