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, 1676🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...