I have allocated 2 meg to each partition table(based on months) in my database. I querried the partitions and I have noticed that only 70% of the space alloacted to each partition has been used.
Is the remaining 30% on each partiton freeable? Or since it has not being used by the partitons that means it's still free for other objects to use.
I am thinking that since they have been allocated to the partiton, then that means they "locked up" in the partiton unless they are freed.
Any explanation will be appreciated.