Sorting on NUMBER or DATE

[Tomislav Petrovic]

Which is more expensive (slower), sorting data using NUMBER field or
using DATE field....
And how much more expensive?

Tomy.

[Ed prochak]

Re: Sorting on NUMBER or DATE

"Tomislav Petrovic" <t.petrovic@ine t.hrwrote in message news:<ca3qhr$gp 0$1@garrison.gl obalnet.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