Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    22

    Unanswered: fragmenting tables in different dbspaces

    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

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    262

    Re: fragmenting tables in different dbspaces

    Originally posted by pd12
    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

  3. #3
    Join Date
    Sep 2003
    Posts
    22
    Hello lloyd,

    Thank you, that was really helpful.

    Regards,
    PD

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •