in
All Tags » table size and index size in Oracle database (RSS)

Browse by Tags

  • table size and index size in Oracle database

    1) Have a table Table_A with 1 million records. Each record (row) has the size 512 bytes. so the table size is 512x1000,000 bytes Is that right? 2) If in Table_A we have PK columns (64 bytes) and 1 NOT NULL constraint (32 bytes), how to estimate the size of index columns? Should it be 64 x 1 million...
    Posted to 11.x (Forum) by software on 04-29-2010
Page 1 of 1 (1 items)