Re: Difference between ROWNUM & ROWID

From: Cleve Sharpe <cleve_at_cbcsf.org>
Date: 1997/09/26
Message-ID: <60h6tk$2lu@news.boca.net>#1/1

Dan Clamage wrote in article <01bcc375$99dd7a30$54110b87_at_clamagent>...

>SKMGMT <skmgmt_at_aol.com> wrote in article
><19970917020100.WAA25417_at_ladder02.news.aol.com>...
>> CAN someone kindly tell me the difference between the two.
>>
>> Also what is Concatenating indexes.
>>

>I've never heard of concatenating indexes... perhaps you mean composite
>indexes? which are indexes composed of more than 1 column from the table.

You are right Dan. A so-called 'concatenated index' is the same as a 'composite key'. From the book, 'Oracle the Complete Reference', a concatenated index is 'one that is created on more than one column of a table. It can be used to guarantee that those columns are unique for every row in the table and to speed access to rows via those columns.'

Cleve Received on Fri Sep 26 1997 - 00:00:00 CDT