Results 1 to 2 of 2

Thread: size of table?

  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: size of table?

    Hi All,
    could you please let me know how can I find the size of table I think

    length of row * number of rows in table

    is it right? or we have other ways.
    Thanks for your help

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: size of table?

    Admin Guide - Planning says (Chapter: Physcial Database Design)

    The number of 4 KB pages for each user table in the database can be
    estimated by calculating:
    ROUND DOWN(4020/(average row size + 10)) = records_per_page
    and then inserting the result into:
    (number_of_records/records_per_page) * 1.1 = number_of_pages
    where the average row size is the sum of the average column sizes,



    Originally posted by David2002
    Hi All,
    could you please let me know how can I find the size of table I think

    length of row * number of rows in table

    is it right? or we have other ways.
    Thanks for your help

Posting Permissions

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