Today we are going to have look on the topic of the Rebuilding index. In this post we are going to learn why do we need rebuilding the index? It explains the steps we use to solve the error.
While we rebuild the index we face the problem.
06:19:09 [SYS][TEST]>> ALTER index PRS.UK_F_HEADER rebuild online;
ALTER index PRS.UK_HEADER rebuild online
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01450: maximum key length (3215) exceeded
The issue was fixed with rebuilding the index without online.
06:24:30 [SYS][TEST]>> ALTER index PRS.UK_HEADER rebuild;
When do we need to rebuild the index?
The only time we need to rebuild indexes is when the cost to rebuild is less than the performance gained.
Rebuilding index helps in the following ways:-
- Index rebuilds can improve SQL performance
- Index rebuilds can be safely automated
- Index rebuilds can release free space
- Blocksize matters ORA-01450
Click here for more information on rebuilding index:-