Global Indexes verses Local Indexes!
Just a quick question really.
I have a table (TableA) with a Primary Key (PK). I have to range partition Table A using a column (CreateDate). As you will know this now means I cannot create the unique index for PK as a LOCAL index and I therefore have to create this as a GLOBAL index. I do not want to be left exposed to indexes becoming unusable and bringing down the system therefore I wanted to check if my suggested solution is correct .........
my proposal would be to sub-partition by PK, would this then mean that I could make the unique index (PK) a local index and I would be free to delete records from TableA without worrying about indexes becoming unusable?
I have a table (TableA) with a Primary Key (PK). I have to range partition Table A using a column (CreateDate). As you will know this now means I cannot create the unique index for PK as a LOCAL index and I therefore have to create this as a GLOBAL index. I do not want to be left exposed to indexes becoming unusable and bringing down the system therefore I wanted to check if my suggested solution is correct .........
my proposal would be to sub-partition by PK, would this then mean that I could make the unique index (PK) a local index and I would be free to delete records from TableA without worrying about indexes becoming unusable?
2