For an Oracle table with 900 columns (mostly varchar(size)), what is the performance impact of insert and update, for wild card select (*) and column name select?
I need to understand the performance impact for a CRUD operation on a table with 50 million rows. Case 1: 200 Columns in a table, Case 2: 900 columns in a table. As 1000 columns is a limit from oracle for a table. System scenarios can be considered as same for both case.
50 million rows is a phenomenal data. Obviously, case 1 performance will be better than case 2 but actual statistics can come only with the real configuration of the servers handling app and databases.
Proper server optimization is required for such big and huge data. What type of configuration is there? What is the environment like OS etc. are also an important part.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: 3  Replies