Presented by:

55543686 10156701292744845 3109607750242402304 o

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!
Download the Slides

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 EDT
Duration:
50 min
Room:
New York Ballroom East
Conference:
Postgres Conference
Language:
Track:
Development
Difficulty:
Medium