Re: fragmentation strategy for archiving question

It depends. If you are querying for a large block of data, using the date column as part of the filter, then you will get fragment elimination. If you are querying for singleton rows using an index, then it's the index which will be scanned, not the data fragments (except for the page(s) with your rows). You will get quicker DSS queries (scan the whole table), but your OLTP performance will not improve. j. On Jan 18, 2012, at 8:22 AM, Floyd Wellershaus wrote: > Hello, > We are being asked to archive off some data from very large tables. They want to keep 2 years worth in the main table and move the rest to another table that may need to be queried infrequently. > Another way of doing that seems to me that may be better, is to partition the table(s) by the create date field, keeping 2 years worth in the main partition and the rest in another partition. > > My questions are: > 1) Will fragment elimination work with regular queries doing it this way or do we need to make use of pdq for that ? > > 2) Assuming fragment elimination works, would this make for quicker queries compared with just removing the older data from the table and putting it in another table ? > > > > Thank you in advance, > Floyd > > > > > Floyd Wellershaus > Dba/Sa Informix/Oracle/Linux/Aix > > http://photos.fwellers.com > ======================================================== > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list