Re: re Rebuilding Indexes in Oracle Apps -- an update

2003-11-04 Thread Tanel Poder
Jared, I don't see how index skip scans could benefit more from a rebuild than from coalesce (providing the index height remains the same). Skip scan doesn't scan the whole index like FFS does, it just does several scans for each value set in beginning of concatenated index (+some more

Re: re Rebuilding Indexes in Oracle Apps -- an update

2003-11-04 Thread Jared . Still
: Subject:Re: re Rebuilding Indexes in Oracle Apps -- an update Jared, I don't see how index skip scans could benefit more from a rebuild than from coalesce (providing the index height remains the same). Skip scan doesn't scan the whole index like FFS does, it just does several scans

RE: re Rebuilding Indexes in Oracle Apps -- an update

2003-11-03 Thread Jared . Still
/2003 12:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: re Rebuilding Indexes in Oracle Apps -- an update Richard et al, {for those who've been following the thread on Rebuilding Indexes ...} I've just been

RE: re Rebuilding Indexes in Oracle Apps -- an update

2003-11-01 Thread Hemant K Chitale
Richard et al, {for those who've been following the thread on Rebuilding Indexes ...} I've just been reading the AskTom thread on rebuilding indexes at http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:6601312252730 and picked on the important line Coalesce... reclaim the