Re: Large table extents

On Wed, 13 Mar 1996, Cheryl Kendricks wrote: } Yes to question 1. Yet, if you have an index and set up query correctly } to use index it will use it. But once a table becomes highly fragmentted } either due to delete or insertions it is a good idea to unload and reload } the table. Or if you have enough space within the dbspace just alter the } index to cluster (this will also unfrag the table). } } } ------------------------------------------------------------------------- } Cheryl Kendricks } Internet: cherylk@spamis.jcdc.doleta.gov } OR } cherylk@prod1.jcdc.doleta.gov } OR } kendric@gwysmtp.jcdc.doleta.gov } DTSI, Inc. Voice: 1-800-598-5008 } Database Adminstrator - DOL Job Corps San Marcos, Texas } ------------------------------------------------------------------------ Thankyou for your reply and the time spent. Your reply is consistent with the others I have recieved - I have tried the things mentioned so it seems like we have disk problems related to HP Logical Volume manager and not Informix. Thanks. Stanton Attree