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!