You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
9 lines
831 B
9 lines
831 B
-- 账户中心分页与用户隔离查询索引
|
|
CREATE INDEX idx_traffic_order_user_created ON traffic_order (user_id, created_at DESC);
|
|
CREATE INDEX idx_traffic_order_user_status_created ON traffic_order (user_id, pay_status, created_at DESC);
|
|
CREATE INDEX idx_traffic_usage_user_created ON traffic_usage_log (user_id, created_at DESC);
|
|
CREATE INDEX idx_traffic_usage_user_source_created ON traffic_usage_log (user_id, source_type, created_at DESC);
|
|
CREATE INDEX idx_sim_card_user_created ON sim_card (user_id, created_at DESC);
|
|
CREATE INDEX idx_sim_card_user_status_created ON sim_card (user_id, status, created_at DESC);
|
|
CREATE INDEX idx_sim_recharge_user_created ON sim_recharge_log (user_id, created_at DESC);
|
|
CREATE INDEX idx_sim_recharge_user_status_created ON sim_recharge_log (user_id, recharge_status, created_at DESC);
|
|
|