Results 1 to 7 of 7

Thread: Resolved: Performance Choice: IF Exists, or use Join

Threaded View

  1. Jan 24th, 2007, 06:47 AM #1
    yrwyddfa
    yrwyddfa is offline

    Thread Starter
    Frenzied Member yrwyddfa's Avatar
    Join Date
    Aug 2001
    Location
    England
    Posts
    1,253

    Resolved Resolved: Performance Choice: IF Exists, or use Join

    I have two tables. I will allow a record to be returned from one table if a bit flag is set in the other. So the question:

    Is it faster to perform an IF EXISTS query the the second table to see if a record exists where the bit is set, or is it better to use an inner join.

    This is solely about performance, and not about pure set semantics.

    Cheers,

    M

    (Using SQL 2k)
    Last edited by yrwyddfa; Jan 24th, 2007 at 10:35 AM.
    "As far as the laws of mathematics refer to reality, they are not certain; and as far as they are certain, they do not refer to reality." - Albert Einstein

    It's turtles! And it's all the way down
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width