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.