Query Hints

Question

Query Hints

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
April 5, 2015 at 3:27 am

#74427

Comments posted to this topic are about the item Query Hints

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 1

A good ( and interesting ) question that I have been able to reply only because I remembered a SQL Server Days session which was about the query hints and the plan recompiles.

Thanks for it.

Hany Helmy SSChampion Points: 13921 More actions · Answer 2

Only using KEEP PLAN, didn`t use the rest yet.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 3

Thanks Steve for the question. I scored 1 mark.

But, one question, does this option has any real significance? Can you please suggest in which circumstances DBA should look for enforcing this option?

Have a great weekend.

Thanks.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 4

Hi SQL-DBA-01 ,

it seems that KEEPPLAN is for mainly for queries using many temp tables

See :

I found only these links which could be interesting for you.

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 5

patricklambin (4/6/2015)
Hi SQL-DBA-01 ,
it seems that KEEPPLAN is for mainly for queries using many temp tables
See :
I found only these links which could be interesting for you.

Cannot see this as specific to temp tables ( more like any high activity tables )

😎

KEEP PLAN
Forces the query optimizer to relax the estimated recompile threshold for a query. The estimated recompile threshold is the point at which a query is automatically recompiled when the estimated number of indexed column changes have been made to a table by running UPDATE, DELETE, MERGE, or INSERT statements. Specifying KEEP PLAN makes sure that a query will not be recompiled as frequently when there are multiple updates to a table.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Thanks. I had to research this one, which is a good way to get the brain moving on a Monday morning.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

akljfhnlaflkj

SSC Guru

Points: 76202

April 6, 2015 at 6:48 am

#1788894

Thanks for the question.

free_mascot One Orange Chip Points: 27169 More actions · Answer 8

Good one, Steve.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 9

RK Mandava

SSCarpal Tunnel

Points: 4153

April 6, 2015 at 7:09 am

#1788900

Good one, Thanks Steve

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 10

Thank you for the post, Steve, really interesting one.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 11

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP