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
Printable View
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
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.