Posts Tagged ‘Index’

ORA-01502: index ‘string.string’ or partition of such index is in unusable state

+6 ORA-01502: index ‘string.string’ or partition of such index is in unusable state Cause: An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation Action: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index […]

Why or When rebuild the Index and Impact of rebuilding????

+15 Why or When rebuild the Index: There have been many discussions about whether rebuilding indexes is useful or not. Generally speaking the need to rebuild b-tree indexes is very rare, basically because a b-tree index is for a very large amount self-managed or self-balanced. Commonly the following reasons for rebuilding an index are: – […]