Databases Reference
In-Depth Information
6.
In the next screenshot, we can see the results of these operations:
7.
Update some data in the table:
UPDATE HR.BIG_ROWS SET field2 = 'B',
field3 = ‹C›, field4 = ‹D›
WHERE MOD(id, 2) = 1;
8.
Analyze the table to refresh the statistics:
ANALYZE TABLE HR.BIG_ROWS COMPUTE STATISTICS;
9.
Verify if there are migrated rows:
SELECT CHAIN_CNT FROM ALL_TABLES
WHERE OWNER = ‹HR› AND TABLE_NAME = ‹BIG_ROWS›;
