Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
l2.partkey = p.partkey -- p.partkey is a column of external query The optimizer displays the query logic as the following logic tree. If the database system cannot view logic tree, the physical plan can be viewed via explain command. Generally, the output is as follows. +---------------+ | Plan