Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: CBO histograms & density
>
> 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