diff options
Diffstat (limited to 'www/optoverview.html')
| -rw-r--r-- | www/optoverview.html | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/www/optoverview.html b/www/optoverview.html index 313d78e..ba79a6c 100644 --- a/www/optoverview.html +++ b/www/optoverview.html @@ -150,7 +150,7 @@ Table Of Contents <div class="fancy-toc1"><a href="#the_min_max_optimization">13. The MIN/MAX Optimization</a></div> <div class="fancy-toc1"><a href="#automatic_query_time_indexes">14. Automatic Query-Time Indexes</a></div> <div class="fancy-toc2"><a href="#hash_joins">14.1. Hash Joins</a></div> -<div class="fancy-toc1"><a href="#the_where_clause_push_down_optimization">15. The WHERE-Clause Push-Down Optimization</a></div> +<div class="fancy-toc1"><a href="#the_predicate_push_down_optimization">15. The Predicate Push-Down Optimization</a></div> <div class="fancy-toc1"><a href="#the_outer_join_strength_reduction_optimization">16. The OUTER JOIN Strength Reduction Optimization</a></div> <div class="fancy-toc1"><a href="#the_omit_outer_join_optimization">17. The Omit OUTER JOIN Optimization</a></div> <div class="fancy-toc1"><a href="#the_constant_propagation_optimization">18. The Constant Propagation Optimization</a></div> @@ -1499,8 +1499,7 @@ SELECT a, (SELECT d FROM t2 WHERE c=b) FROM t1; <a name="pushdown"></a> -</p><h1 id="the_where_clause_push_down_optimization"><span>15. </span>The WHERE-Clause Push-Down Optimization</h1> - +</p><h1 id="the_predicate_push_down_optimization"><span>15. </span>The Predicate Push-Down Optimization</h1> <p> If a subquery cannot be <a href="optoverview.html#flattening">flattened</a> into the outer query, it might still be possible to enhance performance by "pushing down" WHERE clause @@ -1672,5 +1671,5 @@ SELECT * FROM t1 WHERE a=b AND b=5; if those two constraints are true, then it must also be the case that "a=5" is true. This means that the desired row can be looked up quickly using a value of 5 for the INTEGER PRIMARY KEY. -</p><p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/optoverview.in?m=8909f126d6">2024-05-10 14:25:41</a> UTC </small></i></p> +</p><p align="center"><small><i>This page last modified on <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink" data-href="https://sqlite.org/docsrc/finfo/pages/optoverview.in?m=f3bc76d394">2024-07-24 12:16:13</a> UTC </small></i></p> |