Fragmentation of Table

Hi All, We have huge table that will save old data into that table. How should i fragment that table so that it will have any bottleneck on the DB?

Oo0, too much information... How about some more details? IOn general, fragment on some column that lets you control the distribution of data or to easily add a new fragment to contain new historical data and to drop the oldest one when the data is no longer needed. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Nov 11, 2009 at 7:37 PM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > We have huge table that will save old data into that table. How should i > fragment that table so that it will have any bottleneck on the DB? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0015174483dce789a504782499bc

You can use dbschema -d <dbname> -hd <tabname> to get an idea of how to fragment the table. The dbschema command will provide distribution data for the table and how accurate said data is based on your update stats commands. There is good information available in the online doc regarding the output from this command and its interpretation. MM