PolarDB-X优化

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