7 Replies Latest reply on Jan 22, 2014 11:47 AM by Karthick2003

    Improve Table performance(insert,delete & Search) containing large data

    JyotiTyagi


      Hi,

       

       

      I am having a table for maintaining history containing large amount of data & which keeps on increasing and decreasing based on Business Rules.

      I am facing lot of performance issues while searching for any records or while inserting new data into table. I have already applied index to this table but all in vain.

      Also, we use to insert bulk data into this table.

      Can we have any solutions to achieve this. Any help would be highly appreciated.

       

      Thanks in Advance!