Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014
    Posts
    11

    Unanswered: DB2 insert performance: Partitioned vs un-partitioned table

    Hi,

    I've created two tables, one partitioned another non partitioned.
    When I'm inserting data in both the tables (500000 rows each), the time taken by insert is almost same.
    Is this correct, dosen't insert/update in a partitioned table takes more time?

  2. #2
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    if you mean a range-partitioned table, why do you think the difference would be measurable?

Tags for this Thread

Posting Permissions

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