Jaseer V wrote:Almost none. Sometimes the index is faster after a rebuild or after a drop/create than before. Often not.
What is the benefit of index recreation?
How to recreate indexes ?Drop index ...
Jaseer V wrote:I am saddened to see that you are unwilling or incapable to follow simple directions.
Oracle9i Enterprise Edition Release 22.214.171.124.0 - 64bit Production
Edited by: Jaseer V on Oct 13, 2012 9:33 PM