© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
On my laptop, the query takes ~0.8 sec when semi-join is enabled. and 0.01 sec when it is not.
EXPLAINs are same as posted. For both plans, #rows column has values of {275,1,1,1,1,1}, which gives an estimate of about 1375 rows read.