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: CBO histograms & density

Re: CBO histograms & density

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Fri, 15 Nov 2002 15:32:30 +0100
Message-ID: <ar30ga$6r1$1@news.mch.sbs.de>


>
> Although the 50,000 rows may be fairly evenly spread over
> the range, you can get variations in cost if the gaps between
> end values are different. Since you have only 16 buckets,
> can you post the endpoint_number and endpoint_value
> columns (in order, preferably) for this column ?
>

Hi
here's the information:
owner table colum bucket# endpoint_value

SB XXX object_id 0 277292
SB XXX object_id 1 2300317
SB XXX object_id 2 2722412
SB XXX object_id 3 3518422
SB XXX object_id 4 4110683
SB XXX object_id 5 6196801
SB XXX object_id 6 9006510
SB XXX object_id 7 16135376
SB XXX object_id 8 19464286
SB XXX object_id 9 19481135
SB XXX object_id 10 19815369
SB XXX object_id 11 19815370
SB XXX object_id 12 19896336
SB XXX object_id 13 19907124
SB XXX object_id 14 20050590
SB XXX object_id 15 21184688
SB XXX object_id 16 22942865

Stephan Received on Fri Nov 15 2002 - 08:32:30 CST

Original text of this message

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