Re: accessing tables explicitly by index

Hi NiallP,

NiallP wrote:
>
> In Oracle, is there a way to access a single row based on a specific
> index. Here's an example:
> I have a table with a unique index made up from two columns, user_id,
> time_stamp. There may be thousands of rows for each user_id. I want to
> access the most recent row for a particular user_id without having to
> read thousands of rows and finding the max time_stamp. How can this be
> accomplished in Oracle?

select /*+INDEX_DESC(<yourTable> <yourIndex>)*/ * from <yourTable>  where user_id=<yourID> and rownum=1;

HTH
Peter Received on Thu Sep 14 2000 - 01:26:06 CDT