Hi all,
Today we performed a clone of 1 pdb to another pdb.
pdb1 is the source.
pdb2 is the destination.
After the clone finished we did a check to compare the size of the two pdb's.
What was curious was that we discovered that the indexes imported in pdb2 (from pdbs1) were smaller in size then the exact same indexes in pdb2.
For example index a in pdb1 was 2.8gb, the same index in pdb2 was 1.7gb.
The data in the tables was identical.
I was wondering if someone could explain to me why there is a difference in size.