Re: Newbie question on indexes

From one newbie to another:

   Indexes speed performance on large tables. On small ones the difference is small enough to not worry about.

   The Oracle program chooses whether to use an available index when it evaluates your query.

Steve18888 wrote:

> What exactly do indexes do and why do I want to use them? From my
> reading I
> gather that it improves query performances somehow. Digging through
> my manuals
> tells me how to create indexes, but can't find anything on the
> strategy behind
> it. Also, if I create an index, are there any other settings that I
> need to
> make, or do the indexes get used automatically somehow? Thanks - SS
Received on Sun Oct 19 1997 - 00:00:00 CDT