Community

Guidelines for running a reorg on a large table

(Craig Mullins) One of our large tables (12 million rows that continues to grow by 15,000 rows per week) on AIX UDB V7.1 has two indexes — one primary clustered and the other a non-clustered, non-unique index. Reorgchk cmd (F6) recommends to reorg the second index (non-clustered, non-unique). After

Read More - Register for Free Membership

Tags: