4 ms·
Because it's a lot of work tuning complex SQL queries, and you can easily make a coding mistake that runs faster - but produces different results.
by BrentOzar 9y ago
Because it's a lot of work tuning complex SQL queries, and you can easily make a coding mistake that runs faster - but produces different results.
- jzelinskie 9y agoI'm assuming this solver only works on a particular subset of SQL like ANSI SQL. Applications are often coupled to one database by using exotic features and non-portable SQL. In fact, the more you need performance, the more likely you are to leverage these aspects of your database and prevent yourself from using a tool like this.