COST=Blank

ORACLE FINANCIAL is running under RULE BASE ENVIRONMENT not IN COST BASE environment.

 <01bd758e$a189a440$d80b37a6_at_raghus-computer>#1/1,   "rok" <rok_at_MCI2000.com> wrote:
>
> Jason,
> Oracle uses cost based optimization only if you have analyzed the table
> using analyze command. Otherwise it uses rule base optimization. To analyze
> the table use
>
> analyze table <tablename> compute statistics.
>
> I read in ORACLE DBA Handbook that you should not analyze ORACLE Financials
> tables. Also it needs the 4 times the size of a table space in temporary
> tablespace. It can take quite some time.
>
> raghuvir
>
> Jason Selby <jselby_at_cams.co.uk> wrote in article
> <3549E185.ABCB220B_at_cams.co.uk>...
> > Hi
> >
> > When I build a query plan as follows
> >
> > explain plan set statement_id = 'cav032' for
> > SELECT
> > term_key||'|'||term_id||'|'||key_type||'|'||rank||'|'||medical_type
> > FROM cav_mrkey m
> > WHERE NOT EXISTS (
> > SELECT * FROM cav_keys k
> > WHERE m.term_key = k.term_key
> > AND m.term_id = k.term_id
> > AND m.key_type = k.key_type);
> >
> > And display it in SQL*PLUS like so
> >
> > select lpad(' ',2*(level-1))||operation||' '||options||' '||
> > object_name||' '||decode(id,0,'Cost = '||position) "Query Plan"
> > from plan_table
> > start with id = 0 and statement_id = 'cav032'
> > connect by prior id = parent_id and statement_id = 'cav032';
> >
> > I get
> >
> > Query Plan
> > ----------------------------------------------
> > SELECT STATEMENT Cost =
> > FILTER
> > TABLE ACCESS FULL CAV_MRKEY
> > INDEX RANGE SCAN I_CAV_KEYS_TERMIDTYPE
> >
> > Why is 'Cost=' always a blank figure is there another way of getting the
> > overall cost of a query
> >
> > TIA
> >
> > Jason
> >
> >
> >
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 04 1998 - 06:03:04 CDT