Forum Stats

  • 3,757,888 Users
  • 2,251,290 Discussions
  • 7,869,962 Comments

Discussions

Split table partition takes a long time ?

Hi All,

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 ?

Regards,

Irfan