One of my favorites on Oracle is table partitioning. Oracle enables range, hash and list partitioning. The easiest for begginers is range partitioning.
The advantages
A partitioned table may be spread across several tablespaces. It is possible to compress some partitions, change them to read-only status, or even put them offline. Data access will also be faster, provided the WHERE clause properly makes reference to the partition key.
The disavantadges
Partitioned tables always need maintenance, to create the new partitions.
How to do it
posted by Pedro Oliveira @ 4:12 AM
1 Comments:
I would like to appreciate you the way you have shared the post with us. It is really hard to find the quality post, but you have done this job nicely dear.
six month industrial training | Oracle Technologies
Post a Comment
<< Home