question about max pages used
Posted in 2008
Ok a previous post got me checking. according to a join on systabnames and sysptnhdr we have a table with over 11 million npused( pages used ). The table is not fragmented, and I know I can alleviate any future issue by reorging and fragmenting it. But I also noticed that this table has 3 indexes ( some multi-column) that were created with the "in table" clause. I am thinking that if our management doesn't want to take as much downtime, or give me enough space to do the full reorg, that an option I can provide them is to simply drop those indexes and recreate them in their own dbspace, or, even recreate them in the same dbspace without the "in table" clause, which should cause them to be detached by default. ( IDS10UC5). Am I correct in all this ? Thank you, Floyd