The table was partitioned but the range was set to 20, lately the range was exhausted so we increased the range from 20 to 5000. The table had clustered column store index on it so we had to follow these below steps
Drop Clustered column store index on the table
Extended the range by following statement, this was done in loop till 4999 range
ALTER PARTITION FUNCTION partitionfunctionname() SPLIT RANGE (21);
ALTER PARTITION SCHEME partitionschemaname NEXT USED [PRIMARY]Created the Clustered column store index back on the table
Now we see the insertion is taking more time the same operation which would be completed within 10 mins is taking 60 mins. I read about fragmentation does this has to do anything with it
Note: Table is on azure sql database