I have a table with 2 lac revords and 13 colomns. Out of 13 column 7 used as composite primary key. As use that table in query with all that 7 field im where clause, My problem is it take too much time in insert and update and even select.
I cheked its execution plan, that was using range scan as we use date column with between clause. How can i reduce the execution time for dml?
Kindly share your valuable views here, thanks in advance.