Results 1 to 2 of 2

Thread: Index help

  1. #1
    Join Date
    Oct 2011

    Unanswered: Index help

    I'm going to use one of these indexes for a join table query.
    d is the alias for Doctor.

    Is there a difference between the following?
    CREATE INDEX ON Doctor(UPPER(doctorName));
    CREATE INDEX ON Doctor(UPPER(d.doctorName));
    Which one should I make?

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    Yes there is a difference: the second one is an invalid SQL statement and will not run.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts