Oracle - explicit index use

From: <niallp_at_my-deja.com>
Date: Wed, 13 Sep 2000 21:56:04 GMT
Message-ID: <8pot59$ndu$1@nnrp1.deja.com>

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 a 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?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 13 2000 - 16:56:04 CDT