How Does the SQL Server Query Optimizer Work?

Re:How Does the SQL Server Query Optimizer Work? by psi-squared on Thursday January 19, 2017 @04:17PM (#13439578)

There's a really nice article about the Postgres query optimizer, which goes into much more detail about the algorithms used (it's likely that at least the basic ideas are shared with SQL server, though I can't say for sure). I really like the exposition in this:

http://jinchengli.me/post/postgres-query-opt/

[ Parent | on HN ]

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

As a "newer" engine, SQL Server has a couple of tricks that aren't found in most other systems, including intra-query parallelism across multiple threads. This capability requires occasional reshuffling of data between threads, which makes SQL Servers internals a little more like a distributed DBMS (think Netezza/Teradata) than the wonderful, but ancient, Postgres. All of which means that SQL Server has a larger palette of execution options and some different optimization decisions than PG.

[ Parent | on HN ]

Re:How Does the SQL Server Query Optimizer Work? by Someone on Thursday January 19, 2017 @06:29PM (#13440432)

There’s also https://www.sqlite.org/optoverview.html and (more detailed) https://www.sqlite.org/queryplanner-ng.html for SQLite.

[ Parent | on HN ]

Re:How Does the SQL Server Query Optimizer Work? by crench on Thursday January 19, 2017 @04:52PM (#13439796)

thanks for that!

[ Parent | on HN ]