Via va Viaindex

[Rich `Lego-Man' Jesse - 7633]

Richard Witkopp posts:

RW> I can't remember, it's been a long time since I fiddled with
RW> a database very much. But.... if you want it ordered by the
RW> columns in an index, how could that index be anything but the
RW> optimal retrieval method? I guess if you had multiple indexes
RW> using the same columns, but that would make me want to specify
RW> the index even more.

In Oracle's case, if the optimizer determines that your retrieval is faster by
doing a full table scan, it will ignore the index.  This is usually the case
for "small" tables where the minimum of two reads necessary for an index and
data may take longer than just reading in the whole table.

Rich Jesse                              Programmer/Analyst (/DBA/SysAdmin/etc.)
rjesse@qtiworld.com                     Quad/Tech International, Sussex, WI USA
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.