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
