Oracle - Describe when to rebuild an index. posted by
Babu Kunwar
Describe when to rebuild an index.
When we execute more number of insert and update queries for a particular
database we need to rebuild indexes. Secondly when we execute a lot of delete
queries inside a database.
The method that can be used for deciding for re-building of index is by
checking the blevel column inside DBA_INDEXES. When it is greater than four we
can rebuild indexes.
When a row included inside the index is deleted then the index can be rebuild.
More links
What are Cursors?
Define cursor attributes: %FOUND, %NOTFOUND, %ROWCOUNT, and %ISOPEN
What are cursor variables? Explain with an example
Significance of SELECT FOR UPDATE clause. Write syntax
Significance of WHERE CURRENT OF clause. Write syntax..........
|
