Re: where rowid = ...

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 12 Jun 2001 22:18:02 -0700
Message-ID: <3B26F78A.6339147B@exesolutions.com>

Alex Filonov wrote:

> Steffen Ramlow wrote:
>
> > how efficient is a whereclause like:
> >
> > where rowid = '...'
>
> It's the most efficient. And most stupid, too. You can never rely on
> rowid, read documentation.

That is a bunch of nonsense left standing alone as you wrote it. There are certainly situations where it can not be relied upon. But there are an awful lot where it is the best, most efficient, method of locating a record.

If you are going to make statements such as you did you should qualify them with the specific conditions under which they are true. You might, for example, note that EVERY index in Oracle locates records by their rowid and that seems to work pretty darned well.

Daniel A. Morgan Received on Wed Jun 13 2001 - 00:18:02 CDT