Blog Post

Adaptive Joins and Join Hints

,

At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer to: “How do join hints affect adaptive joins?” I don’t know. Let’s find out together. Adaptive Joins Here’s a query that we can run against AdventureWorks: [crayon-5c05a866e92c8264853614/] Without a columnstore index in SQL Server 2017, […]

The post Adaptive Joins and Join Hints appeared first on Grant Fritchey.

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating