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

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

Answer Wiki

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • anand09
    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
    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
    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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: