CODEWITHSUNDEEP
databaseoracle-databaseindexing
Abhimanyu
Abhimanyu

Reputation: 695

Indexing effect on performance while insert , update in oracle database?

I have indexing on columnA , columnB and ColumnC. I have an update query running which is updating columnB and there is another query which is updating columnC initially columnB and columnC will be null.

I have find query which has where clause 

Select * from Tablename where columnA="xyz" or columnB="xyz" or columnC="xyz" ;

I am looking to add composite index on these columns. I want to know what will happen if we run update query does index rebuild every time on all three columns ?

Upvotes: 0

Views: 490

Answers (1)

David Aldridge
David Aldridge

Reputation: 52376

if we run update query does index rebuild every time on all three columns?

When the data in the table changes, the system will perform the required updates on the table's indexes. This will not be a complete rebuild.

Upvotes: 3

Related Questions