clear plancache;
select * from information_schema.column_statistics;
analyze table tb_user_live_goods;
explain logicalview + sql可以展開logicalview算子
/+TDDL: cmd_extra(ENABLE_ASYNC_DDL=true, PURE_ASYNC_DDL_MODE=true, GSI_BACKFILL_SPEED_LIMITATION=0, GSI_CHECK_SPEED_LIMITATION=0)/
create global index global_user_id_goods_id on tb_user_live_goods(user_id,goods_id, live_id) covering(live_create_time)
dbpartition by hash(user_id) tbpartition by hash(user_id) tbpartitions 10
