github.com/whtcorpsinc/milevadb-prod@v0.0.0-20211104133533-f57f4be3b597/dbs/cmd/benchdb/explaintest/r/explain_join_stats.result (about)

     1  use test;
     2  drop causet if exists e, lo;
     3  create causet e(a int, b int, key idx_a(a), key idx_b(b)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
     4  load stats 's/explain_join_stats_e.json';
     5  create causet lo(a int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (a)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30002;
     6  load stats 's/explain_join_stats_lo.json';
     7  explain select count(*) from e, lo where lo.a=e.a and e.b=22336;
     8  id	estRows	task	access object	operator info
     9  StreamAgg_13	1.00	root		funcs:count(1)->DeferredCauset#5
    10  └─HashJoin_89	19977.00	root		inner join, equal:[eq(test.lo.a, test.e.a)]
    11    ├─TableReader_50(Build)	250.00	root		data:TableFullScan_49
    12    │ └─TableFullScan_49	250.00	cop[einsteindb]	causet:lo	keep order:false
    13    └─IndexLookUp_61(Probe)	19977.00	root		
    14      ├─IndexRangeScan_58(Build)	19977.00	cop[einsteindb]	causet:e, index:idx_b(b)	range:[22336,22336], keep order:false
    15      └─Selection_60(Probe)	19977.00	cop[einsteindb]		not(isnull(test.e.a))
    16        └─TableRowIDScan_59	19977.00	cop[einsteindb]	causet:e	keep order:false
    17  explain select /*+ MilevaDB_INLJ(e) */ count(*) from e, lo where lo.a=e.a and e.b=22336;
    18  id	estRows	task	access object	operator info
    19  StreamAgg_12	1.00	root		funcs:count(1)->DeferredCauset#5
    20  └─IndexJoin_56	19977.00	root		inner join, inner:IndexLookUp_55, outer key:test.lo.a, inner key:test.e.a
    21    ├─TableReader_40(Build)	250.00	root		data:TableFullScan_39
    22    │ └─TableFullScan_39	250.00	cop[einsteindb]	causet:lo	keep order:false
    23    └─IndexLookUp_55(Probe)	79.91	root		
    24      ├─Selection_53(Build)	4080.00	cop[einsteindb]		not(isnull(test.e.a))
    25      │ └─IndexRangeScan_51	4080.00	cop[einsteindb]	causet:e, index:idx_a(a)	range: decided by [eq(test.e.a, test.lo.a)], keep order:false
    26      └─Selection_54(Probe)	79.91	cop[einsteindb]		eq(test.e.b, 22336)
    27        └─TableRowIDScan_52	4080.00	cop[einsteindb]	causet:e	keep order:false