From 0076f49aa5ad1cb28dbce0aaf5cdb75a3dd87554 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Thu, 19 Sep 2024 06:07:43 +0200 Subject: Merging upstream version 3.46.1. Signed-off-by: Daniel Baumann --- www/optoverview.html | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) (limited to 'www/optoverview.html') 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
13. The MIN/MAX Optimization
14. Automatic Query-Time Indexes
14.1. Hash Joins
-
15. The WHERE-Clause Push-Down Optimization
+
15. The Predicate Push-Down Optimization
16. The OUTER JOIN Strength Reduction Optimization
17. The Omit OUTER JOIN Optimization
18. The Constant Propagation Optimization
@@ -1499,8 +1499,7 @@ SELECT a, (SELECT d FROM t2 WHERE c=b) FROM t1; -

15. The WHERE-Clause Push-Down Optimization

- +

15. The Predicate Push-Down Optimization

If a subquery cannot be flattened 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. -

This page last modified on 2024-05-10 14:25:41 UTC

+

This page last modified on 2024-07-24 12:16:13 UTC

-- cgit v1.2.3