14 years online, still relevant and current. Those who did the quiz 14 years ago can still benefit for their lessons at that time. use-the-index-luke.com/3-min…

For this WHERE, what index to create? WHERE subsidiary_id = 42 AND last_name LIKE '%INA%' Is (subsidiary_id) enough or should it be (subsidiary_id, last_name)? use-the-index-luke.com/sql/c…

Finding the most recent rows is a common requirement that can often be optimized to become as fast as a primary key lookup. use-the-index-luke.com/sql/p…

A Close Look at the Index Include Clause use-the-index-luke.com/blog/…

The INDEX include clause puts additional columns at the bottom level of an index. They cannot be used to navigate the tree, are not part of the uniqueness of an unique index, but still support index-only scans and are an important documentation tool. use-the-index-luke.com/blog/…

Don't worry about sparse/fragmented indexes—i.e. indexes where the blocks/pages are not full. Regular rebuilds are often doing more harm than good. Here is even an approach how B-trees can intentionally use sparse nodes to improve scalability (CIDR 2021). youtube.com/watch?v=aWbBmV86…

Just a reminder: You can order free stickers in the Use The Index, Luke! shop. use-the-index-luke.com/shop

How to ensure good performance when the database grows? Details that don't matter now can kill performance soon. use-the-index-luke.com/sql/t…

Visualizing SQL Plan Execution Time With FlameGraphs blog.tanelpoder.com/posts/vi…