Re: TO_DATE function causes table scan

From: Jim Smith <jim@xxxxxxxxxxxxxxxxxxxx>
Date: Sun, 2 Apr 2006 09:05:36 +0100

In message <1143812753.260934.116020@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>, dhart@xxxxxxxxxxxxx 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.
.

Prev by Date: htmldb and enterprise manager
Next by Date: universal installer not recording properly
Previous by thread: htmldb and enterprise manager
Next by thread: Re: TO_DATE function causes table scan
Index(es):
- Date
- Thread

Relevant Pages

Re: Clustered index vs. nonclustered index for GUID primary key
... non-clustered seek because a bookmark lookup is not needed. ... clustered index is a B-tree with the actual data pages as leaf nodes. ... > for GUID primary key will result a faster select operation when we look up ...
(microsoft.public.sqlserver.server)
Re: Clustered index vs. nonclustered index for GUID primary key
... non-clustered seek because a bookmark lookup is not needed. ... clustered index is a B-tree with the actual data pages as leaf nodes. ... > for GUID primary key will result a faster select operation when we look up ...
(microsoft.public.sqlserver.programming)
Re: Newbie help
... "Hugo Kornelis" wrote: ... > If I ask you to look at page 364, you'll use the clustered index to find ... > (though not completely he same, as the book is not ordered as a B-tree). ... It could still have a keyword ...
(microsoft.public.sqlserver.programming)
Re: find no.of pages and levels deep
... > Take the authors table as an example in the pubs database... ... > level within that B-Tree? ... level of the clustered index. ...
(microsoft.public.sqlserver.server)
Re: SQL Server Indexing VS. FTS Indexing
... Hilary Cotter wrote: ... > nodes you can to the leaf node very very quickly. ... > These likes will use the clustered index to resolve them and this can ... > SQL FTS performance does degrade significantly if you are returning ...
(microsoft.public.sqlserver.fulltext)