Re: Index Fragmentation strategy

Ashby, David wrote: > > Pete, > > I always prefer to have the indexes in a separate dbspace to the table. > I would put all of the indexes in the one space, and monitor to see if > you start getting excessive IO's on the dbspace. > > Regards > > David Ashby Hi David, that's true. Often it's very important to monitor the index usage. But if your index pages do not reside in the same tablespace as your data pages, you can monitor the index I/O in the following way: database sysmaster - <<eof select sum(pagreads),sum(pagwrites),dbsname,idxname from sysptprof where dbsname = "yourdatabase" and tabname = "yourINDEXname" group by 3,4; eof To run this statistic it's okay when the index is in a seperate tablespace. It's not neccessary to have the index stored in a seperate dbspace. Bye