Re: artificial values vs null

That's funny. I've seen exactly the opposite when using NULL to mean current of anything.

Cheers
Nuno Souto
nsouto_at_bizmail.com.au
----- Original Message -----
From: "Richard Foote" <richard.foote_at_bigpond.com>

> I've seen on quite a number of occasions the damage that "artificial"
> values
> can do in stuffing up Oracle's assumption of range value distributions and
> hence Oracle's ability to select an appropriate execution plan.
>
> Setting end dates to some distant future is full of dangers and is a
> classic
> example.
>
> Beware indeed !!
>

--
http://www.freelists.org/webpage/oracle-l