Re: When is an index used??

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: Sun, 10 May 1998 01:09:44 -0700
Message-ID: <6j3csq$iep@bgtnsc03.worldnet.att.net>

1. When the "field" is used in the WHERE clause, i.e. WHERE field <some_condition>
2. When using the INDEX hint (from Oracle7 on).

Hope this helps.

Michael Serbanescu

---

Matthias Kramer wrote:
>
> I use PO7 via Delphi-BDE. When I excute I simple SQL-Statement like
>
> SELECT field FROM table ORDER BY field
>
> there's no difference between there does exist an index on "field" or does
> not.
> I can't imagine that this is normal. Any explanations for that phenomenon
> ??
>
> Matthias Kramer
Received on Sun May 10 1998 - 03:09:44 CDT