Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2005
    Posts
    73

    Unanswered: Size of the table ....

    UDB 8.2 FP7
    OS: Sol 2.8

    HI , I got a couple of questions.

    How do i find the total size of an existing table ? I mean how much space it occupied currently.

    2) How do i estimate the growth for a new table?

  2. #2
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Arrow Growth

    Or do runstats and check table size from the Control Center

    Concerning growth:

    Estimate how many new rows you get pr. day and multiply it
    by row storage requirement, i.e. the sum of space requirements
    for all columns in your table.

    If you have varchar columns the porcess migth be a little harder
    because ypu have to assigne probalilties to the length of the
    string inserted in each variable column

    Good Luck
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    There are other considerations as well ... Eg. max number of rows in a page is 255 ...
    Have a look at the documentation

    http://publib.boulder.ibm.com/infoce...n/c0004924.htm

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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