Re: Rowids

Spetc@aol.com wrote: > > A few questions regarding rowids : > > 1. Apart from when tables are fragmented, can they be regarded as truly > unique, in terms of pointing to a particular row, for the lifetime of a > table? > > 2. Is it faster to to get a record using it's rowid rather than it's serial > id. (if there is one)? In on-line the rowid depends on the page it's on and I believe thee offset in the page. So the answer is no, it is not the same for the life of the record.