on 06-27-2018 1:47 PM
Hi All,
I have a huge table contains around 50bn data, on which we have range partition, each partition contains around 13mn records, while we are dropping the partition using
alter table .... drop partition ... command , it takes around 1 and 1/2 hours to complete, while truncating the partition data, takes lesser time like 40 mins, using below command
truncate table .... partition ....
My concern is , why drop is so lazier than, truncate ?
I was assuming drop hardly takes 5 to 10 mins, though I never tried so !!
Regards
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.