Timeline for Oracle 12c, Will dropping partition which has 25% of total data, rebuild the indexes?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 1, 2017 at 15:47 | history | edited | atokpas | CC BY-SA 3.0 |
added 158 characters in body
|
| Mar 1, 2017 at 15:39 | history | edited | atokpas | CC BY-SA 3.0 |
added 158 characters in body
|
| Mar 1, 2017 at 10:05 | comment | added | BriteSponge | As per the last sentence quoted above the actual dropping of a partition is a meta data operation so will only involve updates to a handful of records. Basically it will be quick. | |
| Mar 1, 2017 at 9:26 | history | edited | atokpas | CC BY-SA 3.0 |
added 288 characters in body
|
| Mar 1, 2017 at 8:45 | comment | added | Viraj | This is very useful information. Do you have any idea about time duration of this operation, given that this partition has most amount of data ? Will it take several hours or partition drop happens reasonable time ? ( with in seconds or minutes) | |
| Mar 1, 2017 at 7:46 | history | answered | atokpas | CC BY-SA 3.0 |