Hello All,

I have got quite a few dbspaces available and would like to frgamnet my tables.
I would like to ask, how fragmentation is going to help me?
As i have lots of inserts and am concern about performance?
It is a daily process and have lots of rows in the same.
Please suggest!!

Thanks and Regards,
PD

Hi PD

If you have many inserts on a table, then its advisable to go in for fragmentation. Fragmentation distributes data from a table into seperate dbspaces, thus it enables parallel scans, sorts & joins.
It will definetely improve performance. You can visit the below link for more info.

http://pipin.tmd.ns.ac.yu/databases/informix/4364.pdf


Regards,

lloyd

Hello lloyd,

Thank you, that was really helpful.

Regards,
PD