REPOST: Re: DO or DONT Analyze SYS Objects ?

Andreas Wizemann doodled thusly:

>1) Do i need to use COMPUTE STATISTICS or should i use ESTIMATE (?
>rows or ? Percent)

up to you. if all workd well with estimate, then leave it. careful with some bugs with estimate that cause it to sample much less than 1/3 the table.

>
>2) What about Objects from user SYS ? Analyzing or not ?
>

no. never.

>Any Hints ?

use them in the SQL when all else fails.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam

• WAS CANCELLED BY =======: Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r From: nsouto_at_optushome.com.au.nospam (Nuno Souto) Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel <3c2e6bc7.1523810_at_news> Control: cancel <3c2e6bc7.1523810_at_news> Date: Mon, 31 Dec 2001 08:52:59 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.3c2e6bc7.1523810_at_news> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009788867 26548 166.102.15.34 (31 Dec 2001 08:54:27 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 31 Dec 2001 08:54:27 GMT X-No-Archive: yes Comment: Anarchy! Fuck You! X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999) and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes

This message was cancelled from within Mozilla...not Received on Sat Dec 29 2001 - 19:21:19 CST