I have this query which has asked by top banking company in an interviews.
If all the columns in a table are indexed will it going to improve the performance while doing any dml operation on the same table.
Note:We have no space issue in index table space.The table on which index would be made is very big.
Also can it improve the select query performance.
Kindly share your views.