© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
The first plan shows that the key is copied from table t, rather then from the materialized table. The last record in table t is ('t','t'). So the key to access table t1 always is built over this record. This explains why we have a wrong result for the first plan.