| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: online index rebuilds - FFS or FTS
I thought "fast full index scan" was just another name for "index full scan"?
-----Original Message-----
From: Jonathan Lewis [mailto:jonathan_at_jlcomp.demon.co.uk]
Sent: Monday, January 30, 2006 2:06 PM
To: tanel.poder.003_at_mail.ee; Roger Xu; joseph_at_amalrajinc.com; Bobak,
Mark; ORACLE-L
Subject: Re: online index rebuilds
You can actually get an index full scan
(rather than fast full scan) for an offline
index rebuild - and I thnk I decided the
choice was cost-based even back in 8i.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 10th Jan 2006
Hi,
Thinking about why full table scan is required for online index rebuild... Maybe the potential index block splits are the reason why index FFS can't be used for online index rebuild? Consistent reads should overcome this issue though, but maybe there is something we don't know...
Btw, with offline index rebuild the decision whether to go with FTS or index FFS is also cost based (at least 10.2). If I have only single-column table indexed then the offline rebuild may do an FTS instead of fasf full index scan. (also, even in the case of fast full index scan, rows have to be sorted anyway, because index fast full scan doesn't guarantee an ordered result).
Tanel.
For technical support please email tech_support_at_dp7uptx.com or you can
call (972)721-8257.
This email has been scanned for all viruses by the MessageLabs Email Security System.
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 30 2006 - 15:20:27 CST
 |
 |