Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: TO_DATE function causes table scan

Re: TO_DATE function causes table scan

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Sun, 2 Apr 2006 09:05:36 +0100
Message-ID: <NiK266zQX4LEFwRq@jimsmith.demon.co.uk>


In message <1143812753.260934.116020_at_g10g2000cwb.googlegroups.com>, dhart_at_t2systems.com writes
>One other thing to note is that I am always going to grabbing the
>latest records out of this table (RE: where ALM_DATE >=
>TO_DATE('03-19-2006 06:26:45', 'MM/DD/YYYY HH24:MI:SS'). In SQL Server
>I would create a clustered index (leaf node of the b-tree points
>directly to the data) on the ALM_DATE field and this would improve
>performance dramatically. Does Oracle have a silver bullet like this?
>Or will a regular index work fine?

The equivalent is an index-organised table. If the table gets very large (unlikely at 10000 rows per day), partitioning on ALM_DATE might also help.

-- 
Jim Smith
I'm afraid you've mistaken me for someone who gives a damn.
Received on Sun Apr 02 2006 - 03:05:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US