When Should I Use An Index Hint?

preview_player
Показать описание
Index hints are useful tools that are easily abused. In today's video, learn when it's appropriate to use an index hint and when they should be avoided.

Blog post with demo code:

Follow me on Twitter:
  1. Bert Wagner
  2. SQL Server
  3. SQL
  4. SQL training
  5. index hints
  6. database hints
Рекомендации по теме
When to use 0:18:43

When to use A and AN | Grammar Lesson (PART 1) Indefinite Articles

English Grammar: Should 0:07:39

English Grammar: Should you use DO or BE?

Learn to use 0:04:02

Learn to use would + could + should in sentences - English Fluency Teacher

How to use 0:14:43

How to use the modal SHOULD in English

How often should 0:00:39

How often should I use Glycolic Acid?

Should I use 0:05:54

Should I use mouthwash everyday?

WHAT CODEC SHOULD 0:06:06

WHAT CODEC SHOULD I USE? | adult swim smalls

Should I Use 0:02:20

Should I Use An Index Fund To Save For A House?

What should you 0:00:30

What should you use first? Conditioner OR Hair Mask?

SHOULD YOU USE 0:01:00

SHOULD YOU USE MINOXIDIL FOR HAIR GROWTH OR HAIR LOSS TREATMENT? #shorts

Should You Use 0:00:49

Should You Use Confirm Edit On Release?

Should You Be 0:09:27

Should You Be ONLY Using 12/2? When Can You Use 14/2?

Correct use of 0:17:11

Correct use of could would and should | Modal Verbs | Could Would Should Grammar

You Should Use 0:03:13

You Should Use Your AC in Your Car in The Winter! Here's WHY

Use Of Should, 0:11:28

Use Of Should, Would and Could Correctly In English Speaking? Modal Verbs | English Through Hindi

Should you use 0:05:31

Should you use a VPN? | VPN explained

Why Should I 0:04:54

Why Should I Use a Health Savings Account (HSA)?

When Should I 0:01:08

When Should I Use Oil—Before or After Showering? | Ayurveda Q&A | #AskBanyan

Use of Could, 0:00:42

Use of Could, Would, Should In English Questions | Modal Verbs | Grammar | #englishshorts Ananya

4 Wheel Drive 0:07:22

4 Wheel Drive Modes, Which Should You Use?

Alan Resnick - 0:14:57

Alan Resnick - What Codec should I use?

When should you 0:07:01

When should you use a mortgage broker?

Resume Tips You 0:00:28

Resume Tips You Should Use

Part 3 0:20:29

Part 3 Why and when should we use an abstract class

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

Pls elaborate on "fixing the root cause". I agree index hints are bad, but if statistics are updated and everything else is in order to let SQL Server choose the best plan and it still does not, then index hints (in rare cases) might be a life saver...

TorgeirFredriksen
Автор

Yet another reason I hate index hints: If you remove or rename an index used in a hint, you completely break that query using the index hint. The optimizer won't be able to produce a plan if the hinted index doesn't exist. On the plus side, this can break your application in a rather spectacular fashion. Just ask the application that broke a few weeks ago when I dropped a duplicate index.

AMtwobe