Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Performance: Dates vs Varchar2
Lets say we store time/dates of certain events in a table and we want
to select all events for a certain day. Which method will be faster
(02/13/2002 is the in-parameter, can/should be replaced with bind
variable)?
It will be easier to compress the index in B but for this discussion, lets assume we don't use compression.
Oracle 8.1.6.3 Enterprise Edition on Solaris Received on Wed Feb 13 2002 - 10:08:38 CST