Re: Hash indexes

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/22
Message-ID: <01bcc752$7f18d1f0$54110b87@clamagent>#1/1

For selects you should run an explain plan on your query and tune it. You can also use optimizer hints (they look sorta like comments as in /*+ INDEX .. ). Check the Oracle docs on optimizing queries.

"Mark Webb" <mwebb_at_cix.compulink.co.uk> wrote in article <EGwLH6.Iv4_at_cix.compulink.co.uk>...
> Oracle newbie question: Using Ingres I could choose to
> use a hash index to get the fastest inserts and exact
> match index finds. What should I be doing in Oracle
> please?
>
> Mark W.
>
Received on Mon Sep 22 1997 - 00:00:00 CDT