Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why "Separating Data and Indexes improves performance" is a m yth?
Man, I wish I lived in your world...
Rich
Rich Jesse System/Database Administrator rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
> From: Tim Gorman
> Sent: Friday, April 23, 2004 12:15 PM
>
> The other two methods, FULL SCAN and FAST FULL SCAN, are not
> often used
> during queries, but are most often used during ALTER INDEX
> ... REBUILD or
> when index usage is explicitly hinted but not really
> appropriate.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Apr 23 2004 - 12:20:03 CDT
![]() |
![]() |