What is the performance impact of insert and update in Oracle table?

anand09

15 pts.

Tags:

Oracle

Oracle Table

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?

Software/Hardware used:
Oracle

Asked: November 29, 2017 8:24 AM Last updated: December 4, 2017 9:29 AM

Answer Wiki

Last updated: November 29, 2017 3:43 PM GMT

ToddN200099,905 pts.
History
Contributors
- Ordered by most recent
- ToddN200099,905 pts.
- Michael Tidmarsh62,155 pts.

Thanks. We'll let you know when a new response is added.

Tough to tell how the performance will be without the computer specs. Some computers will perform much better depending on the processor and amount of memory. 900 columns does seem large for a table, but the issue is the number of rows in the table as well.

Discuss This Question: 3 Replies

anand09 Nov 30, 2017 8:14 AM GMT

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.

15 pointsBadges:

report
Jaideep Khanduja Nov 30, 2017 9:04 AM GMT

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.

17,465 pointsBadges:

report
Subhendu Sen Dec 4, 2017 9:29 AM GMT

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.

103,660 pointsBadges:

report