Rebuild Index in Oracle Database

How to Rebuild Index in Oracle Database Tutorial Example

Run Query Editor then copy & paste the below rebuild index on a tablespace in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR
   -- Syntax : ALTER INDEX index_name REBUILD TABLESPACE tablespace_name LOGGING/NOLOGGING

   ALTER INDEX         IDX_EMPLOYEE
   REBUILD TABLESPACE  USERS
   NOLOGGING;
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How to Rebuild Index in Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..