Re: Newbie question on indexes

From: Peter van Rijn <pvanrijn_at_xs4all.nl>
Date: 1997/10/18
Message-ID: <34491F7B.F4D9EF60@xs4all.nl>#1/1

Steve,

When I first started using Oracle I learned a lot from reading the "Oracle Server Concepts" - manual.
Chapter 5 (version 7.2) describes "Schema objects", and Indexes belong those objects.

Peter

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 Sat Oct 18 1997 - 00:00:00 CDT