Shulou(Shulou.com)06/01 Report--

If the index of the database has frequent Delete operations, it may lead to a lot of fragmentation of the index. Therefore, in some cases, it is necessary to re-REBUILD all the indexes in order 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! = (256 * 1024) AND owner = USERSQL > spool off)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.