Dean Harding wrote:
Like I said, the ROWID in Oracle is the *physical address* of the row.
It's made up of three parts: datafile, block and offset. If you say:
select * from some_table where rowid='RRRBBFFF';
In that case, I'm more confused about why anyone would want to specify
"ORDER
> >In Oracle, because the ROWID is the actual physical address of the
row,
> >it provides O(1) access to a row, as opposed to O(log(n)) that an
index
> >provides. That's a pretty good benefit if you ask me.
> >
>
> I'd love to see the math on that proven; I'm running it through my
head
> now and
Dean Harding wrote:
still taking up a few bytes per row of memory, like it or not.
Some logic ... statement 1:
The ROWID isn't stored by Oracle (except in your indexes).
... does not coincide with statement 2:
It's "stored" in the same space that MySQL would allocate for
... these
> >The thing with Oracle is that once a row is assigned a ROWID, it
never
> >changes. It doesn't matter if the row grows and has to move within
the
> >block (or if it has to move to another block, for that matter).
That's
> >why ROWIDs work in Oracle.
> >
>
> Neither does an auto_increment index
Dean Harding wrote:
The thing with Oracle is that once a row is assigned a ROWID, it never
changes. It doesn't matter if the row grows and has to move within the
block (or if it has to move to another block, for that matter). That's
why ROWIDs work in Oracle.
Neither does an auto_increment i
ge-
From: [EMAIL PROTECTED] [mailto:horizonx@;noos.fr]
Sent: Thursday, 14 November 2002 9:52 pm
To: [EMAIL PROTECTED]
Subject: Re: _rowid
Hi Benjamin,
> > Isn't _rowid some type of internal variable? What is its exact
> purpose and
> > significance?
Thanks for nailing the matte
Hi Benjamin,
> > Isn't _rowid some type of internal variable? What is its exact
> purpose and
> > significance?
Thanks for nailing the matter down.
> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:msn:39492:cnfpdcnkgalicmjgekef
"My main concern is that if we would make ROWID's available for the
Hello.
On Wed 2002-11-06 at 10:59:36 +0100, [EMAIL PROTECTED] wrote:
> What about the following info in the manual p. 55?
>
> "Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
> 3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this
> is of type intege
[EMAIL PROTECTED] wrote:
"Add a PRIMARY KEY or UNIQUE key to the table and use this. New in Version
3.23.11: If the PRIMARY or UNIQUE key consists of only one column and this
is of type integer, one can also refer to it as _rowid"
Isn't _rowid some type of internal variable? What is its exact p
