Re: Sorting on NUMBER or DATE

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 8 Jun 2004 10:06:18 -0700
Message-ID: <4b5394b2.0406080906.51ab358e_at_posting.google.com>


"Tomislav Petrovic" <t.petrovic_at_inet.hr> wrote in message news:<ca3qhr$gp0$1_at_garrison.globalnet.hr>...
> Which is more expensive (slower), sorting data using NUMBER field or
> using DATE field....
> And how much more expensive?
>
> Tomy.

Considering that dates are internally stored as numbers, it would be difficuly to tell the difference.

IF your concern really is the performance, then make a benchmark test on Your hardware with Your data. Because in performance issues there are only guidelines, no hard rules. And keep in mind that your test data better be very close to real data or your production performance could differ from your test performance. And usually not on the better side of the line 8^)

hth,
  Ed Received on Tue Jun 08 2004 - 19:06:18 CEST

Original text of this message