12 Replies Latest reply: Jul 10, 2014 9:01 AM by BartCern RSS

    Insert in slow on 135 GB table

    Niket Kumar

      database version :

      OS: HP UNIX


      We have 135 GB table which have almost 350 columns and insert is slow on this table(take 40-50 seconds).This table have one materialized view log and have three indexes.One index is on date column and two indexes are on  number column.....


      How can we make insert faster on this table...

      Is there any bottleneck with insert performance...how do it check it.