RailsConf 2017: The Secret Life of SQL: How to Optimize Database Performance by Bryana Knight

[@dkennell998]

I'd always been confused about what exactly indexes were; thanks for breaking it down so nicely!

[@jasdeepsinghgrover2470]

Another rule... Always remember your functional dependencies... Conditions on dependent columns can be converted to conditions on independent columns which generally have indexes. Like to get all apples a redundant condition on object type to be fruit can help

[@m.purushothamreddy4901]

nice talk thanks for the knowledge.

[@luisalfonzogonzalez2265]

She is awesome!!! LOVED HER EXPLANATION

[@alfredoscoppa9455]

Awesome talk! I would add that PG planner is probably very smart and that could be the reason why PG intentionally excluded something like index hint.

[@codyelhard8012]

I thought indexes were magic before this video

[@grawlixes]

This talk was great. Thanks!