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, 1675🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...