Re: TO_DATE function causes table scan

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.