Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2012
    Posts
    7

    table size , row size , database size

    Hi guys

    could i please know how to determine the table size then row and column size and database size through sql query ?

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Consider writing SQL that will calculate the total size of a row (using average length for variable length columns) times the expected number of rows. Then as the last bit of this query, add the overhead associated with tables for whatever database product you are using.

    Then do the same thing for the indexes to be implemented ((index * length) + overhead).

    The sum of these oversimplified calculations will give an approximation of what you asked.

  3. #3
    Join Date
    Sep 2012
    Posts
    7
    if you dont mind cud u please send me the query thank you .

Posting Permissions

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