Xref: alice comp.databases.oracle.server:22291
Path: alice!news-feed.fnsi.net!news.idt.net!woodstock.news.demon.net!demon!news.demon.co.uk!demon!rwx777.demon.co.uk!steve
From: Steve Haynes <steve@rwx777.demon.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Star queries and analyse?
Date: Sat, 6 Jun 1998 23:25:29 +0100
Organization: .
Message-ID: <IWLWwEAZHce1Ew8N@rwx777.demon.co.uk>
X-Trace: news.demon.co.uk 897171974 nnrp-03:752 NO-IDENT rwx777.demon.co.uk:158.152.187.113
X-Complaints-To: abuse@demon.net
MIME-Version: 1.0
X-Newsreader: Turnpike (32) Version 3.05 <qJ+TbpkSJhEaoMwCxBmDsEYxb7>
Lines: 11

Hi All,
The cost based optimiser needs to know the 
relative size of tables 
(and have star_transformation_enabled=true or star hint I believe). 
My question is that if you only estimate 10000 rows (less than actual)
then the optimiser won't reconise it as a fact table. 
Does that mean you should estimate 50% or so on the fact table?
Steve
-- 
"The floggings will continue until morale improves."