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

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