PowerBI Data Analyst - Create visualizations and dashboards from scratch
Save 40% on 3 months of Coursera Plus
Overview
Coursera Spring Sale
40% Off Coursera Plus Annual!
Grab it
Explore database query optimization beyond the conventional wisdom of adding indexes in this 49-minute conference talk that challenges common performance assumptions. Discover the hidden performance killers that lurk in databases, including inefficient query patterns, misused joins, transaction overhead, and bloated statistics through real-world scenarios where traditional indexing solutions failed. Learn about smarter alternatives and optimization strategies that go beyond simply adding another index to your database schema. Examine live demonstrations that reveal surprising insights into query performance bottlenecks and gain actionable takeaways for optimizing database queries more effectively. Master advanced techniques for identifying and resolving performance issues that indexes alone cannot solve, making this essential viewing for both database veterans and developers looking to deepen their understanding of query optimization fundamentals.
Syllabus
It’s Not Always About the Index: The Hidden Secrets of Query Performance - Avishag Sahar
Taught by
NDC Conferences