RE: non fragmented tables

bala peddi <bala.peddi@fmr.com> wrote: > What is the best method to find non fragmented table and > fragment those non fragmented tables > > Thanks in advance > > BALA > bala.peddi@fmr.com > The way to find them is to look at systables and sysfragments (where = fragtype =3D "T"). As to the best way to introduce fragmentation, that = depends on the data, the method of access, how often it is archived, the = storage devices you have, the types of queries you run, whether your = database is OLTP or DSS focused... There's no quick answer on that one. RET +------------------------------------------+ | Richard Thomas | | DBA - Marketing Information Systems | | Optus Communications | | email: richard_thomas@yes.optus.com.au | | Ph: +61 2 9342 7188 | | "My opinions are my opinions" | +------------------------------------------+