Re: Views, predicates and partition-elimination

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Sat, 21 Apr 2001 13:56:35 GMT
Message-ID: <3ae19008.33469814@news-server>

On Sat, 21 Apr 2001 10:55:40 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>Does it make any difference if you deliberately
>coerce the date strings to date type ?
>

Man! I really hate this one. It's so simple, yet so easy to overlook. IMHO, one of the worst "features" of ORACLE's automatic type conversion and probably more responsible for "performance problems" than any other.

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat Apr 21 2001 - 08:56:35 CDT