Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I still believe CBO is better than RBO, but WTH?

Re: I still believe CBO is better than RBO, but WTH?

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Sat, 08 Sep 2001 16:04:13 GMT
Message-ID: <3b9a4112.15002608@news>


On Sat, 8 Sep 2001 16:34:27 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>When I said 'cardinality' I meant the figure coming
>from the cardinality column of the explain plan -
>however, that might actually be the number you've
>printed against each line anyway.

yup.

>
>Can you give us the index definitions - i.e. list
>of columns - for each of the three indexes used,
>and whether they are supposed to be unique
>or not, and which columns are nullable.

I'll get them tomorrow. Too late now, I must catch some ZZZZs.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Sat Sep 08 2001 - 11:04:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US