sistemas 95572 (1/29/2010)

---

Assuming that:

* the inner select returns a reasonable amount of rows - so it fits in memory

shouldn't the IN statement be better since the inner query executes...

mike.anderson 52709 (1/28/2010)

---

CirquedeSQLeil (1/28/2010)

---

mike.anderson 52709 (1/28/2010)

---

mark.ross (1/28/2010)

---

One of the reasons that the query plans are identical could be that the table being selected from in the 'IN' and 'EXISTS' clause...

Because the 'IN' clause, when run against a large number of rows could, potentially, return a large number of values to check against, whereas the 'EXISTS' clause should still only...

Here's an alert for this. Some folks, myself included, have been getting an 'interesting' display of answers to choose from.

I was shown 3 radio buttons arranged vertically. The...

If you think of it sort of as a number line, the name "Christopher" would occupy spots 1 thru 11 of the line. The expression is askiing you to...