Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for Jack Douglasâ€
Type | On... | Excerpt | Status | Date |
---|---|---|---|---|
Answer | — |
A: Why would excluding records by creating a temporary table of their primary keys be faster than simply excluding by value? > Why would the second way be faster? Generally speaking, the first form will perform worse (as well as looking a lot worse) than the second. You are hitting an edge case where the opposite is true, because: 1. The `not in` in your first example is likely to be transformed into an anti-join (so... (more) |
— | almost 4 years ago |