github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/optgen/exprgen/testdata/scan (about)

     1  exec-ddl
     2  CREATE TABLE abc (a INT, b INT, c INT, INDEX ab(a, b))
     3  ----
     4  
     5  expr
     6  (Scan [ (Table "abc") (Cols "a") ])
     7  ----
     8  scan t.public.abc
     9   ├── columns: t.public.abc.a:1(int)
    10   ├── stats: [rows=1000]
    11   ├── cost: 1050.02
    12   ├── prune: (1)
    13   └── interesting orderings: (+1)
    14  
    15  expr
    16  (Scan [ (Table "abc") (Index "abc@ab") (Cols "a,b") ])
    17  ----
    18  scan t.public.abc@ab
    19   ├── columns: t.public.abc.a:1(int) t.public.abc.b:2(int)
    20   ├── stats: [rows=1000]
    21   ├── cost: 1050.02
    22   ├── prune: (1,2)
    23   └── interesting orderings: (+1,+2)
    24  
    25  expr
    26  (Root
    27    (Scan [ (Table "abc") (Index "abc@ab") (Cols "a,b") ])
    28    (Presentation "a,b")
    29    (OrderingChoice "+a,+b")
    30  )
    31  ----
    32  scan t.public.abc@ab
    33   ├── columns: a:1(int) b:2(int)
    34   ├── stats: [rows=1000]
    35   ├── cost: 1050.02
    36   ├── ordering: +1,+2
    37   ├── prune: (1,2)
    38   └── interesting orderings: (+1,+2)
    39  
    40  expr
    41  (Select
    42    (Scan [ (Table "abc") (Cols "a,b,c") ])
    43    [ (Eq (Var "a") (Const 1 "int")) ]
    44  )
    45  ----
    46  select
    47   ├── columns: t.public.abc.a:1(int!null) t.public.abc.b:2(int) t.public.abc.c:3(int)
    48   ├── stats: [rows=10, distinct(1)=1, null(1)=0]
    49   ├── cost: 1080.03
    50   ├── fd: ()-->(1)
    51   ├── prune: (2,3)
    52   ├── interesting orderings: (+1,+2)
    53   ├── scan t.public.abc
    54   │    ├── columns: t.public.abc.a:1(int) t.public.abc.b:2(int) t.public.abc.c:3(int)
    55   │    ├── stats: [rows=1000, distinct(1)=100, null(1)=10]
    56   │    ├── cost: 1070.02
    57   │    ├── prune: (1-3)
    58   │    └── interesting orderings: (+1,+2)
    59   └── filters
    60        └── eq [type=bool, outer=(1), constraints=(/1: [/1 - /1]; tight), fd=()-->(1)]
    61             ├── variable: t.public.abc.a:1 [type=int]
    62             └── const: 1 [type=int]