ORACLE : HOW TO CHECK INDEX FRAGMENTATION.

Share via:

HOW TO CHECK INDEX FRAGMENTATION.

When a database is frequently updated via UPDATE, or DELETE statements we can expect it to become fragmented over the time.
If database indexes are fragmented, the SQL  query optimizer may chose a non-optimal execution plan when using an index to resolve a query.
This will affect the overall query performance and you may notice a query behaving slower than normal.

OUTPUT : 

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (9 votes, average: 4.00 out of 5)
Loading...

Add Comment