Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    23

    Unanswered: Table rebuild - extent size

    Has anyone a script that will calculate the optimum extent size for an existing table.

    Ta

    Kelv

  2. #2
    Join Date
    Apr 2004
    Posts
    3
    Calculate the size of table and then allocated initial extent

  3. #3
    Join Date
    Mar 2004
    Location
    Netherlands
    Posts
    183
    Hi,

    Suvarnagalgali gave the correct answer. You could get this information from the table sysptnhdr table in the sysmaster database. Check for npused. The relation with the table is the partnum which is also specified in the systables table of the database under investigation.

    Rob Prop

Posting Permissions

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