Excess No. of Fields
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Excess No. of Fields

  1. #1
    Join Date
    Sep 2001
    Location
    India
    Posts
    2
    Dear Friends
    If the No. of fields in a table are more i.e in the order of 100s
    then is there any performence degradation of the database?
    can anybody explain me in detail ?

    regards

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Oracle can handle upto 1000 fields per table. It will be dependand on the number of indexes on the table and speed of which the data is inserted. I have a patitioned table with 125 columns and 5 indexes, and it doesn't have any problems inserting 3.5 million records per day. Although, I did have a table with 5 Columns and every column was indexed inserting 770 records per second... funny enough, Oracle fell flat on it's face on a Sune450 4 processes and 2 GB of ram.
    OCP 8i, 9i DBA
    Brisbane Australia

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