Collections:
Rebuild an Index in Oracle
How To Rebuild an Index in Oracle?
✍: FYIcenter.com
If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script:
SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME TABLE_NAME UNIQUENES ----------------------- --------------------- --------- EMP_EMAIL_UK EMPLOYEES UNIQUE EMP_EMP_ID_PK EMPLOYEES UNIQUE EMP_DEPARTMENT_IX EMPLOYEES NONUNIQUE EMP_JOB_IX EMPLOYEES NONUNIQUE EMP_MANAGER_IX EMPLOYEES NONUNIQUE EMP_NAME_IX EMPLOYEES NONUNIQUE ALTER INDEX EMP_NAME_IX REBUILD; Statement processed.
⇒ Show Table Columns Used in an Index in Oracle
⇐ Recovered Tables with Indexes in Oracle
2019-04-17, 1773🔥, 0💬
Popular Posts:
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...