Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
5 check-ins related to "omit-subquery-order-by"
|
2021-07-16
| ||
| 22:43 | Try to omit the ORDER BY clause in subqueries if doing so does not change the result in any way. See Forum post 2d76f2bcf65d256a for details and history. (check-in: 85ddaf1b59 user: drh tags: trunk) | |
| 20:16 | Minor comment improvements. (Closed-Leaf check-in: 6854b5919b user: drh tags: omit-subquery-order-by) | |
| 01:19 | Get the "omit ORDER BY in FROM-clause subqueries" optimization working for the core test cases. (check-in: e31c588865 user: drh tags: omit-subquery-order-by) | |
|
2021-07-15
| ||
| 19:29 | Attempt to omit ORDER BY clauses from FROM-clause subqueries if those ORDER BY clauses do not affect the output. See forum thread 2d76f2bcf65d256a for discussion. This can help the query flattener in some cases, resulting in faster query plans. The current implemention does not always work. (check-in: ef97c3e7c3 user: drh tags: omit-subquery-order-by) | |
| 16:39 | Change references to the schema table in sqlite3_analyzer to the new SQLITE_SCHEMA name. (check-in: 3beb77d6a7 user: drh tags: trunk) | |