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: Unique index not being used, up to date stats

Re: Unique index not being used, up to date stats

From: Ben <balvey_at_comcast.net>
Date: 29 Jan 2007 13:37:15 -0800
Message-ID: <1170106634.991227.219870@q2g2000cwa.googlegroups.com>

On Jan 29, 4:24 pm, "jerni..._at_kochind.com" <jerni..._at_kochind.com> wrote:
> Was there any bad data inserted into the table with an abnormally high
> or low value? What is the max and min for that column. I have seen
> this change the plan.

the max and min is a little out of whack, due to two different next number routines being used, but the numbers are listed in the above thread, I don't think there are enough of the lower values to throw it off that bad. Received on Mon Jan 29 2007 - 15:37:15 CST

Original text of this message

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