Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: partition and subpartition

    On what basis the patition and sub partition to be made,
    If I make more subpartition say 128 will it improve the perforance


  2. #2
    Join Date
    Mar 2002
    Reading, UK
    Increasing the number of partitions or subpartitions reduces the number of rows per partition, so queries which go in on a partition will have less work to do, also partition based operations may be quicker. However the maintanence of partitions may become more time consuming and thus take more of your time.

    Partitions can be very useful indeed but you should fully understand all the possible options with partitioning and do testing to find the best one for your particular app. Also consider what partioning maintanance jobs will have to be created. The concepts manual is especially useful.


Posting Permissions

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