Friday, January 28, 2011

what is the use of Partition?

If you created PPI on table, then data at AMPs is ordered using Partion column

for example, if we have Partion on deptno then all dept 10 records at one place at AMP.
and dept 20 records at one place.....etc

I.e it creates partitions

When you query data on deptno, only corresponding partition will be read

No comments:

Post a Comment