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

    Unanswered: UDB Engine Optimizer and APPEND ON

    Has anyone defined tables with APPEND ON and seen a difference in a plan's access path with that option?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    New rows will always be inserted at the end of the table when APPEND is on. I don't think it will affect anything else.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Sep 2003
    Posts
    85
    Thanks, Marcus. I understood what APPEND ON does. It's just that I'm grasping at straws since I've seen a change in access path (before and after from db2expln) and trying to figure out what changed that might have caused the change.

Posting Permissions

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