DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2000
    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
    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.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.