Optimal Table Size for Oracle Databse Table...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Optimal Table Size for Oracle Databse Table...

  1. #1
    Join Date
    Aug 2000
    Posts
    68
    Hello There

    I just want to ask a quick question of you all.

    Do you have any insights on the following?

    What are the Postives & Negatives of creating a large
    table on a database with around 500 fields.

    Also this table could have up to 6-8 million records.

    This Table would also have to have a lot of indexes & get appended to on a daily basis?

    Many Thanks For any advice recieved....
    Carpe Diem

  2. #2
    Join Date
    May 2002
    Posts
    42
    you have ONE table with 500 columns!?!?

    how big would 1 row be? if it is more then one oracle block size you will not be able to store the row using one block. This is not ideal but happens a lot.

    first try to break up the table in to smaller tables and link with foreign keys. If this is not possiable then you must partitioin the table. find a logical grouping of the data and partition the table along these lines.

    Andrew
    OCP

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