aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/backend/optimizer/README5
1 files changed, 2 insertions, 3 deletions
diff --git a/src/backend/optimizer/README b/src/backend/optimizer/README
index 7ae2b74b2c2..fc0fca41071 100644
--- a/src/backend/optimizer/README
+++ b/src/backend/optimizer/README
@@ -757,9 +757,8 @@ to create a plan like
-> Seq Scan on SmallTable1 A
NestLoop
-> Seq Scan on SmallTable2 B
- NestLoop
- -> Index Scan using XYIndex on LargeTable C
- Index Condition: C.X = A.AID and C.Y = B.BID
+ -> Index Scan using XYIndex on LargeTable C
+ Index Condition: C.X = A.AID and C.Y = B.BID
so we should be willing to pass down A.AID through a join even though
there is no join order constraint forcing the plan to look like this.