Results 1 to 2 of 2

Thread: Performance DB2

  1. #1
    Join Date
    May 2011

    Question Unanswered: Performance DB2


    i wish listen your opinions about performance of treatments (AS400/DB2) with this scenario described below:

    Imagine that i have a table with 2.500.000 records, the table have indexes created.

    I have many aplications batch and interactif that access to this table, always using the key. (the applications are developed with cobol/400)

    If i will remove 1.800.000 records from the table (stay with +/- 700.000) do you think that i will win something significant in terms of performance?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    If ALL of your queries and ALL of your DML use the indexes so that they only read the exact number of rows they have to, then you will not see any performance gain, because you are at 100% efficiency for the table. This is rare if not unattainable as it is highly unlikely that for every possible query/DML you have an optimal index for it. So reducing the number of rows should provide some sort of performance gain since you will be probably be reading fewer rows somewhere.


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