Re: Oracle 7.3.2.3 not using Indexes

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/09/27
Message-ID: <342d6692.3084400@www.sigov.si>#1/1

On Sat, 27 Sep 1997 15:02:09 +0200, Martin Haltmayer <Martin_Haltmayer_at_KirchGruppe.de> wrote:

>> ....[SNIP]....
>I assume your access rights to your indexes are correct (remember you
>can have different access rights on data and index!).

This must be something new !!??? Can you explain how can you grant access rights on a table to someone and restrict him the ability to use the coresponding indexes?

AFAIK you can only grant/revoke the ability to CREATE indexes on a table, but not the ability to use the indexes of the table. And you can not grant/revoke any privileges on indexes explicitely!

>If none of the indexes are used, try the hint /*+ index (ALIAS
>INDEXNAME) */ in the regarding select statement.
>
>....[SNIP]....
>--
>Martin Haltmayer

Regards,

---

Jurij Modic                             Republic of Slovenia
jurij.modic_at_mf.sigov.mail.si		Ministry of Finance
============================================================

The above opinions are mine and do not represent any official standpoints of my employer Received on Sat Sep 27 1997 - 00:00:00 CDT