- 3,722,589 Users
- 2,244,362 Discussions
- 7,849,966 Comments
Split table partition takes a long time ?
I've some question, i try to add new range partition with split partition method, but it took a long time for finished 1 new range partition it's almost 1 hour to do that, my table size is 194 GB and i use this query for split partition,
ALTER TABLE IONPAY.TB_TRANS_REQ SPLIT PARTITION TRANS_REQ_999999 AT (20210301) INTO (PARTITION TRANS_REQ_20210301, PARTITION TRANS_REQ_999999);
My question is, what it running so long , and there's a way to make it faster for add new range partition, or what should i check ?