Rebuilding indexes in Oracle

The index of the database if there are more frequent Delete operations, it can cause the index to produce a lot of fragmentation, so, at some point, all indexes need to be re-REBUILD to merge index blocks, reduce fragmentation, and improve query speed. Sql> set heading offsql> set feedback offsql> spool d:index.sqlsql> SELECT ' alter index ' | | index_name | | ' Rebuild ' | | ' Tablespace INDEXES Storage (initial 256K next 256K pctincrease 0); ' From All_indexeswhere (tablespace_name! = ' INDEXES ' OR next_extent! =) and owner = Usersql>spool off

This article is from the "Elanjie" blog, make sure to keep this source http://elanjie.blog.51cto.com/11847332/1912364

Rebuilding indexes in Oracle