Hello,
we are running Oracle 8171 using the CBO (Cost Based Optimizer).
I'm currently setting up a cron job to do a analyze on "all" objects
on a regular basis.
Now i have 2 Questions:
- Do i need to use COMPUTE STATISTICS or should i use ESTIMATE (?
rows or ? Percent)
- What about Objects from user SYS ? Analyzing or not ?
Any Hints ?
Thanks
Andreas Wizemann
- WAS CANCELLED BY =======:
Path: news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!uunet!ash.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
From: Andreas Wizemann <AWizemann_at_fvvag.de>
Newsgroups: alt.config,comp.lang.c,comp.databases.oracle.server
Subject: cmsg cancel <p2ml2uspfep93agpenvc7ujhv5nm76v0kh_at_4ax.com>
Control: cancel <p2ml2uspfep93agpenvc7ujhv5nm76v0kh_at_4ax.com>
Date: Mon, 31 Dec 2001 06:49:20 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.p2ml2uspfep93agpenvc7ujhv5nm76v0kh_at_4ax.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009790054 28060 166.102.15.34 (31 Dec 2001 09:14:14 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 31 Dec 2001 09:14:14 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 Thu Dec 27 2001 - 02:17:22 CST