Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why a rebuild speeds up my queries.
If you have Oracle 9.2.0.5, you should go with locally managed
tablespaces with automatic segment space management and report
the results to this list. Pay no attention to oracle alerts warning
about the possible segment corruption.
-- Mladen Gogala Oracle DBA email:mladeng_at_aetvn.com Ext: 9787Received on Wed Sep 01 2004 - 19:31:26 CDT
> -----Original Message-----
> From: David Sharples [mailto:dsharples_at_cerebrussolutions.com]
> Sent: Wednesday, September 01, 2004 10:49 AM
> To: oracle-l_at_freelists.org
> Subject: RE: Why a rebuild speeds up my queries.
>
>
> Thanks Cary, migrated rows definitely looks the way to go.=20
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
![]() |
![]() |