DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sizing help

  1. 05-24-2001, 05:58 PM #1
    rnv
    rnv is offline Junior Member
    Join Date
    May 2000
    Location
    dallas,tx,usa
    Posts
    32
    Tablesize - setimated 2000
    Number of rows expected 100000

    What is a good value for storage parameters initial and next ?
    Currently I am defaulting all initial , next etc to tablespace setting which is 50K



    Reply With Quote Reply With Quote
  2. 05-25-2001, 01:19 AM #2
    Halo
    Halo is offline Moderator
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    50k is probably small. Initial and next depend on the growth rate of the table. You probably want to go with an initial of #rows*avg/max_row_length.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules

Click Here to Expand Forum to Full Width