Analysing SYS tables

From: g.r.s. deisz <g.r.s.deisz_at_ptt-telecom.unisource.nl>
Date: 1997/12/05
Message-ID: <669689$opm@hdxl16.telecom.ptt.nl>#1/1

Hi all,

Does someone have any experience using the cost-based optimiser to access tables owned by SYS?
Oracle Support advises not to analyse SYS tables in order to make sure the rule based optimiser will be used accessing these tables. Does this mean that Oracle has not been able to make the cost based optimiser good enough to guarantee performance?

Thanks in advance,

Stefan.

--
Name      :G.R.S. Deisz
Phone     :+31-50-5855954
E mail    :G.R.S.Deisz_at_PTT-Telecom.Unisource.NL
DISCLAIMER:This statement is not an official statement from, nor
           does it represent an official position of, PTT Telecom BV.

Received on Fri Dec 05 1997 - 00:00:00 CST