"Why isn't my query using an index?" - Tips on SQL performance to keep on your finger tips!
Denish Patel's background spans a wide depth and breadth of expertise and experience in SQL/NoSQL database technologies. Using this knowledge, he helped to architect and designed numerous successful database solutions addressing challenging business requirements. Denish is a Sr. Database Architect/Database engineer. He holds an MBA from the Johns Hopkins University and a BS in Computer Science, and has spoken at various conferences around the globe. He has experience working with various industries and companies - Medallia, WithMe, OmniTI.
If you are a Developer and/or a DBA, you must have come across this question: "why isn’t my query using an index?" This session explores the factors that influence the Postgres optimizer’s approach to this question. Learn about the concepts of cardinality and histograms and hear how these affect the optimizer's calculations. See a demonstration of how these concepts work in practice using real SQL queries. This session is intended for Developers and DBAs who want to learn the basics of how the optimizer chooses between an index range or full table scan and how to speed up SQL.
- 2019 March 20 15:00 EDT
- 50 min
- New York Ballroom East
- Postgres Conference