github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/xform/testdata/rules/stats (about) 1 exec-ddl 2 CREATE TABLE abc (a INT PRIMARY KEY, b INT, c INT, INDEX b(b), UNIQUE INDEX c(c)) 3 ---- 4 5 exec-ddl 6 CREATE TABLE xyz (x INT PRIMARY KEY, y INT, z INT, INDEX y(y), UNIQUE INDEX z(z)) 7 ---- 8 9 rulestats 10 SELECT * FROM abc JOIN xyz ON a=x 11 ---- 12 Normalization rules applied 0 times. 13 Exploration rules applied 8 times, added 5 expressions. 14 Top exploration rules: 15 CommuteJoin applied 2 times, added 1 expressions. 16 GenerateMergeJoins applied 2 times, added 2 expressions. 17 GenerateLookupJoins applied 2 times, added 2 expressions. 18 GenerateIndexScans applied 2 times, added 0 expressions.