Cost Based Optimisation is the de-facto standard way to optimise SQL queries in most modern databases. It is the reason why it is really really hard to implement a complex, hand-written algorithm in a 3GL (third generation programming language) such as Java that outperforms a dynamically calculated database execution plan, that has been generated from…

Samuel Maudo

Couchbase

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

The post evaluates 10 SQL optimizations that do not depend on the cost model. It discusses the applications and support for transitive closure, removing 'silly' predicates, JOIN elimination, provably empty sets, and more.

10 Cool SQL Optimisations That do not Depend on the Cost Model

<p>Looks like a table of Early Blockbuster movie rental days</p>
