Missing Index Mishaps

preview_player
Показать описание


  1. Erik Darling (Erik Darling Data)
  2. sql server
  3. SQL Server
  4. Indexing
  5. query tuning
  6. Index
Рекомендации по теме
Missing Index Mishaps 0:12:05

Missing Index Mishaps

Why are Missing 0:07:14

Why are Missing Index Hints Missing (by Amit Bansal)

More Of What 0:13:29

More Of What Missing Index Requests Miss In SQL Server

MySQL : How 0:00:58

MySQL : How to find Missing Indexes in MySQL?

SQL Server | 0:04:17

SQL Server | Missing Index Hint is Missing

Databases: Missing Index 0:02:54

Databases: Missing Index Not Displaying In Execution Plan

4.5 Getting SQL 0:06:03

4.5 Getting SQL Server's Recommendations on Missing Indexes

Sql Server query 0:05:53

Sql Server query optimization identifying missing indexes

Why Missing Index 0:08:53

Why Missing Index Hints can't always be Trusted

Relation view missing 0:01:03

Relation view missing phpMyAdmin fix

Missing Indexes Do's 0:59:56

Missing Indexes Do's and Don'ts

How Clippy Designs 1:11:27

How Clippy Designs Indexes for Microsoft SQL Server

Databases: Is it 0:02:35

Databases: Is it OK to blindly add missing indexes? (3 Solutions!!)

How to Use 0:07:23

How to Use sp_BlitzIndex

SQL Server Diagnostic 0:10:16

SQL Server Diagnostic Queries - Part 13

VR Ride Accident 0:00:08

VR Ride Accident

Back to Indexes 1:07:26

Back to Indexes - The Original Culprit - Amit Bansal's TechEd Europe 2013 session!

Cuidado com a 0:11:42

Cuidado com a missing index!

3 Mistakes Data 0:08:56

3 Mistakes Data Scientists Make Leading to Missing Data

Worst amusement park 0:00:21

Worst amusement park accidents😰 #shorts

403 Forbidden Error 0:02:28

403 Forbidden Error | Website Not Working | Missing Index.php File

Built-In SQL Server 1:09:25

Built-In SQL Server Tools Make Query Tuning Easier - Week 4

What, Where, Why, 1:07:32

What, Where, Why, and How of Indexes - Gail Shaw

Warren Buffett's Shocking 0:01:00

Warren Buffett's Shocking Investment Mistakes: He Lost $5 Billion! #money #shorts

Комментарии
Автор

Great Video. Sound only on the left side...

oneofthepagans
Автор

For the sake of completeness... how would you refactor the stored procedure for better estimates?

stefanotorelli
Автор

Great video Erik! Thanks!

If someone runs into this situation, and they need BOTH queries to be fast, I'd assume a "hot" fix would be to add an index hint on the original query that now takes 14 seconds to run? How does SQL Server react in your scenario if you do so?

Also, I think for some reason the sound only plays out of the left speaker for this video.

sqldevdba
Автор

so what happens when you add the missing index to cover the query in the stored proc (on OwnerUserid, ParentId, PostTypeID) ? Would the optimizer choose that over the second missing index with ParentID as the leading column? I assume so...

josephobrien