When should I reorg?

At what point should a reorganization of a table be considered?

I have a table that has 48 extents, and two indexes of 77 and 23
extents each. The time required to read this table sequentially has
dropped significantly recently after many new rows were added.

The table is 334 meg and containst 41,785 blocks. The two indexes are
450 meg and 288 meg in size with 60,000 blocks and 36,000 blocks
respectively.

Thanks for all replies
Wardell Castles

.

Relevant Pages

  • Re: Around/About
    ... Michael Hamm wrote: ... >> reorganization." ... Mike. ... Prev by Date: ...
    (alt.usage.english)
  • Re: any one here who wants to brag a bit?
    ... Loved the site and the reorganization, when will more photos be added? ... Also, Sharon, now, how do you like AR versus IN? ... Prev by Date: ...
    (alt.sewing)
  • Re: Gores "battlefield promotion"
    ... > Where are they hiding the exemption list on http://www.pgatour.com/ ... I can't find it since the last reorganization of the web ... complain, and it's still a great site. ... Prev by Date: ...
    (rec.sport.golf)
  • Do extents impact speed?
    ... I am managing a number of systems that were built before I was ... Many of these have a large number of extents. ... Prev by Date: ...
    (comp.databases.informix)
  • Re: MAXEXTENTS on Informix 7.3
    ... No - you can't change the max number of extents for a structure. ... function of the partition page for that structure, ... IBM ... Prev by Date: ...
    (comp.databases.informix)