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