Results 1 to 6 of 6
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Unanswered: In(),not In(),exist(), Not Exist(), !like()

    I want the performance of IN(),NOT IN(),EXIST(), NOT EXIST(), LIKE(), NOT LIKE() In sql 2005
    Which one is slower in execution and which is best to fetch records as per execution time.
    Anybody have any ideas ?
    Last edited by AnushreeDarshane; 07-03-09 at 07:01.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Nope, I can't understand what you're asking at all. Maybe someone else will, but I think you'd be better off if you tried to rephrase your question.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Dec 2010
    Posts
    1

    Got Answer

    Hi Anushree,
    I am also facing same question.
    It will be appreciated if you could post the answers if you have.
    Also have one more question searching answer from last 2 years.....

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    The answers are:

    1) It depends on the data
    2) It depends on what criteria determine "best"
    3) Yes.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    As Pat said. Typically, though, exists and not exists should be faster, due to they only look for a single occurence of some condition. Though, there are times that the IN can be used for index matching and it would be faster.
    Dave

  6. #6
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    No sig spam yet? You guys are getting lazy.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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