Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Querying index values

Re: Querying index values

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: 1998/10/21
Message-ID: <70kbpo$i8r$1@schbbs.mot.com>#1/1

I understand that if you initiate a query and Oracle can get all it needs from using a suitable index it will do so and not have to hit the actual table itself at all. A good tuning technique this one.

I'm not sure you can actually pull the ROWID of the record from the index though. Unless anyone knows different?

--
Alan D. Mills


Jagdish Rajan wrote in message
<362cf520.859668708_at_netnews.worldnet.att.net>...

>Is there any way for me to query an index? Given an index with values
>2, 5, 7, 8, 9, 12 I would like to be able to submit a query to find
>the next index value after 7. Ideally I would also like to get the
>rowid associated with 7, in case I have duplicate index values.
>
>Thank you,
>Jagdish.
>
Received on Wed Oct 21 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US