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