Re: fragmented system tables

Determine the initial extent size you will need for the existing data. based on your growth expectations, calculate your next extent sizes. Unload the table in question. preferably with the hpl. drop the table, recreate it with the new extent sizes and reload your data. Jorge :) Sven Tolkemit wrote: > Hi people, > > we discovered, that the system tables (systables,sysindexes, etc.) on > our Online 7.23.UC1 are very fragmented. We think, this leads into > performance problems. Is there a way to defragment the tables? > > Thanks for answer! > > Sven -- Jorge Torralba Intel Corporation Technology and Manufacturing Grp HF2-71 Sys. MFG, Information Technology 5200 NE Elam Young Pkwy (503)696-4587 Hilssboro, OR 97124 jorge.torralba@intel.com ============================================================= Any views or opinions expressed by me do not reflect those of Intel Corp **** **** **** * * * * * * **** * * * * *** *** * * **** **** **** * * * * * * * * * * *** *** * * * * * ** * * * * * * * * *** * * * *** * * * * * * * * * * * * * * * * * * * * * * * *** * * * * * * * * * * * * * * * * * * * * * * * * *** *** * * * * * * * * * * * * * **** **** **** ******* ******* **** * * * ****** * * ******