Re: Table performance over time

From: lfree <windows-free_at_163.com:s/windows/linux/>
Date: Tue, 27 Apr 2004 08:56:22 +0800
Message-ID: <c6kb84$oif$1@news.yaako.com>

> Watching the performance of several tables decline over time. Is there
> a standard process to perform on tables that have lots of
> updates,inserts and deletes on them ? I know from experiance that an
> export/import will improved performance, but that's not feasible
> except in the case of an emergency restore.
>
> Using the Rule based optimizer, so I don't think analysing the tables
> will make any difference ? (Why I'm using RBO is a whole different
> subject)
>
> Unix Solaris 2.7 (migrating to 2.8 next month)
> Oracle 8.1.6 (migrating to 9I this summer)

you open the table of parallel,if open the table of parallel, the explain plan
is CBO.

I suggest you use CBO,that is better than RBO. Received on Mon Apr 26 2004 - 19:56:22 CDT