Forum Stats

  • 3,722,589 Users
  • 2,244,362 Discussions
  • 7,849,966 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

Sign In or Register to comment.