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 Bruce Aldermanâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Edit | Post #279101 | Initial revision | — | about 4 years ago |
| Answer | — |
A: Are there best practices for sticking conditions in WHERE clauses vs the JOIN statement? SQL is a declarative language, and the form of the query does not dictate the form of the query plan that actually retrieves the data. So these two queries might be not only the same speed, but actually map to the exact same query plan to be executed. So if speed and results don't give an advantag... (more) |
— | about 4 years ago |