Oracle explicit index
From: NiallP <niallp_at_my-deja.com>
Date: Thu, 14 Sep 2000 14:38:02 GMT
Message-ID: <8pqns6$q50$1_at_nnrp1.deja.com>
Date: Thu, 14 Sep 2000 14:38:02 GMT
Message-ID: <8pqns6$q50$1_at_nnrp1.deja.com>
[Quoted] 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 Thu Sep 14 2000 - 16:38:02 CEST