How to Design Indexes, Really

Speaker: Bill Karwin Karwin Software Solutions MySQL users commonly ask: Here's my table, what indexes do I need? Why aren't my indexes helping me? Don't indexes cause overhead? This talk gives you some practical answers, with a step by step method for finding the queries you need to optimize, and choosing the best indexes for them.

Join Today
Domain-Driven Design
▶︎

Domain-Driven Design

Things every developer absolutely, positively needs to know about database indexing - Kai Sassnowski
▶︎

Things every developer absolutely, positively needs to know about database indexing - Kai Sassnowski

AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)
▶︎

AWS re:Invent 2018: Amazon DynamoDB Deep Dive: Advanced Design Patterns for DynamoDB (DAT401)

Data Modeling for Power BI [Full Course] 📊
▶︎

Data Modeling for Power BI [Full Course] 📊

Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker
▶︎

Turing Award Winner: Disagreeing with Google, Postgres, Future Problems | Mike Stonebraker

How To Think SO Clearly People Assume You're Brilliant
▶︎

How To Think SO Clearly People Assume You're Brilliant

Functional Programming in 40 Minutes • Russ Olsen • GOTO 2018
▶︎

Functional Programming in 40 Minutes • Russ Olsen • GOTO 2018

Data Warehouse Tutorial For Beginners | Data Warehouse Concepts | Data Warehousing | Edureka
▶︎

Data Warehouse Tutorial For Beginners | Data Warehouse Concepts | Data Warehousing | Edureka

Scaling Instagram Infrastructure
▶︎

Scaling Instagram Infrastructure

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
▶︎

Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF

Power BI Dataflows Tutorial and Best Practices [Full Course] 📊
▶︎

Power BI Dataflows Tutorial and Best Practices [Full Course] 📊

SQL CTE (Common Table Expression) Visually Explained | Full Guide WITH Clause | #SQL Course 28
▶︎

SQL CTE (Common Table Expression) Visually Explained | Full Guide WITH Clause | #SQL Course 28

Google & AWS Veteran: What Top Tier Software Architects Do Differently
▶︎

Google & AWS Veteran: What Top Tier Software Architects Do Differently

Power BI Data Modeling Portfolio Project End-to-End (Nightmare Data Model)
▶︎

Power BI Data Modeling Portfolio Project End-to-End (Nightmare Data Model)

Avicii, Dua Lipa, Coldplay, Martin Garrix & Kygo, The Chainsmokers Style - SUMMER DEEP HOUSE Mix
▶︎

Avicii, Dua Lipa, Coldplay, Martin Garrix & Kygo, The Chainsmokers Style - SUMMER DEEP HOUSE Mix

The Scariest Chart in Electrical Engineering
▶︎

The Scariest Chart in Electrical Engineering

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra

Learn Databricks in Under 2 Hours
▶︎

Learn Databricks in Under 2 Hours

Learn Web Design For Beginners - Full Course
▶︎

Learn Web Design For Beginners - Full Course

But what are Hamming codes? The origin of error correction
▶︎

But what are Hamming codes? The origin of error correction

Excel for Finance and Accounting Full Course Tutorial (3+ Hours)
▶︎

Excel for Finance and Accounting Full Course Tutorial (3+ Hours)

PostgreSQL Crash Course - Beginner Tutorial
▶︎

PostgreSQL Crash Course - Beginner Tutorial

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra
▶︎

System Design Explained: APIs, Databases, Caching, CDNs, Load Balancing & Production Infra

SQL Tutorial - Full Database Course for Beginners
▶︎

SQL Tutorial - Full Database Course for Beginners