Re: NUMBER vs NUMBER (n)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 30 Sep 2006 23:33:40 +0200
Message-ID: <ugoth29m1hmpcpdrtepnvqjbd0vfoilnt9@4ax.com>

On Sat, 30 Sep 2006 10:09:39 -0700, DA Morgan <damorgan_at_psoug.org> wrote:

>
>But Sybrand's point is important as well. Oracle typically does a far
>more efficient job joining number than strings.

Actually, if those numbers were stored as binary numbers: on O/S level number comparisons are often performed as mere subtractions. String comparisons aren't. In my case Oracle would typically need to compare at least 5 leading '0's before finding a difference.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Sep 30 2006 - 16:33:40 CDT