Another thing that I recall, if I am correct, the freed ROWIDs (after
deleting rows) are assigned to newly inserted rows.
Aleem
-Original Message-
Sent: Thursday, February 21, 2002 11:18 PM
To: Multiple recipients of list ORACLE-L
Subject:ROWID datatype columns
Can someone explain to me why some developers like to create ROWID datatype
columns in their tables?
I am wondering why they sometimes do that instead of using primary keys.
I searched for info on this on the Web, but nothing.
ROWID access is probably faster than index access, I guess.
I
In my previous job, ROWIDs were used left-and-right for performance benefits
(accessing a row using ROWIDs is the fastest)and were integral part of the
Appl Design at that time. Other than performance, I do not know why one
would want to use it. However, it prevented us (Tech Support, SDBA) from
PROTECTED]
618-622-4145
-Original Message-
From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 12:18 PM
To: Multiple recipients of list ORACLE-L
Subject: ROWID datatype columns and primary keys
Can someone explain to me why some developers like
: ROWID datatype columns and
primary keys
Sent by:
[EMAIL PROTECTED
practice for the reasons
you mention.
Jared
Boivin, Patrice J [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/21/02 10:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:ROWID datatype columns and primary
Patrice,
The only reason I can think of creating a column with a datatype of ROWID,
is in order to store a rowid. Why you need to store the rowid escapes me
as the rowid is available as a pseudocolumn anyway.
It is also dangerous to store this rowid in a column, as it can change.
During and
A rowid column can be put to very good use in transitional tables for batch
processing or temporary tables. For example, check out the CHAINED_ROWS
table that Oracle creates via the utlchain.sql script. I've seen this
technique in the commercial Banner Utilities application from SCT. It may be
a
