How Does the SQL Server Query Optimizer Work?

Re:How Does the SQL Server Query Optimizer Work? by rjbwork on Thursday January 19, 2017 @08:47PM (#13441154)

I'm running SQL Databases on Azure SQL, and it gives you recommendations to add indexes, and various other optimizations, that take 1 click to have happen. I get an email, and I can have the index created via a link in my email.

It's pretty fantastic.

[ Parent | on HN ]

Re:How Does the SQL Server Query Optimizer Work? by blitzd on Thursday January 19, 2017 @10:19PM (#13441525)

It based on functionality that all exists in the traditional on-prem SQL Server as well - certainly not the e-mail and point a click creation, but you can definitely query SQL Server DMV's for missing index information[1].

As with any suggested indexes though, they have to be weighed against their effect on other workloads. Additional indexes can have a big impact on inserts / updates / deletes.

[1] https://blogs.msdn.microsoft.com/bartd/2007/07/19/are-you-us...

[ Parent | on HN ]

Re:How Does the SQL Server Query Optimizer Work? by rjbwork on Friday January 20, 2017 @07:33AM (#13443325)

Definitely true - it can't be mindless, but it's nice that it's put in front of my face w/ no effort.

[ Parent | on HN ]