Presented by:

Ee744035c05d417d3ca9f93bb382e3fe

Denish Patel

PostgreSQL

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.

No video of the event yet, sorry!

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.

Date:
2019 March 20 15:00
Duration:
50 min
Room:
New York Ballroom East
Conference:
Postgres Conference
Language:
Track:
Development
Difficulty:
Medium