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

Thread: Sizing estimate : Using Erwin

  1. #1
    Join Date
    Nov 2000
    Posts
    416

    Question

    This is a data modeling question : I define a table in ER/Win 3.5.1 data modeling software and then in it's volumetric editor, I say that the initial row counts for this table is 1000000 records estimate then when I forward engineer the data model I like ER/Win create the storage part of my table automatically based on the row counts estimate I gave to it. Does ER/Win intellegent enough to do that and if yes how?


  2. #2
    Join Date
    Jan 2001
    Posts
    126
    Hi,

    It must be having in-built logic based on # of fields, field type and length. Based on the blocksize, pctfree it must be computing the number of blocked required for the given number of rows and then arriving at initial extent size.

    Baliga

Posting Permissions

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


Click Here to Expand Forum to Full Width