title: Should I use index on frequently updated table in oracle
body: <p>I have a table where we will inserting 1000 records per minute and updating the same records to change the status in the next minute on the basis of 2 columns.I am planning to create separate index on the 2 columns. Is it advisable to create one index on both the columns or separate index on 2 columns. We will be selecting on both the columns frequently.</p>