Re: TO_DATE function causes table scan

From: Jim Smith <>
Date: Sun, 2 Apr 2006 09:05:36 +0100
Message-ID: <>

In message <>, 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 - 10:05:36 CEST

Original text of this message