Re: oracle create index

From: Tanel Poder <tanel_at_@peldik.com>
Date: Tue, 22 Jul 2003 20:09:42 +0300
Message-ID: <3f1d6fd5$1_1@news.estpak.ee>

Hi!

> I see, I was unaware of this. So tell me if I understand correctly, if I
> create an index of a field, and name it 'whatever' then I make a query
using
> that original field, Oracle will see there is an index for it and use it
> automatically???

Yes.
Even better, Oracle's Cost Based Optimizer is able to choose the best indexes and join mechanisms for retrieving rows, based on statistics and it's calculations on your data.

> I am running Oracle 9.2.0.2.

Welcome to the wonderful world of Oracle ;)

Tanel. Received on Tue Jul 22 2003 - 12:09:42 CDT