Re: Help on rowid (SE 5.0) - Reminder

In article <4f54f0$hic@cssun.mathcs.emory.edu>, javi@psi.ernet.in (javeed anwar t) says: > > > >What I want to know is : > >Suppose I do a partial scan or total scan on this table before and after >deletion, how will be the performance of the system? I want to know because >I doubt since the rowid's are not physically deleted it may degrade the >performance in the second case. > >Also, let me know how the rowid behaves when that particular record is >deleted from the table and how does an indexed scan filter the records? I get the feeling that you may have mis-understood the role of rowids . A rowid is unique for the life of a table. If you drop the table and reload it a particular row of data may have a new rowid. Otherwise rowids start counting up from 1 and are never reused. The performance of a table may depend on how many rows are in it, but not what the values of the rowids are. If the table is well designed and indexed then performance may not even be dependant on number of rows in the table. A rowid is just a unique key given to each row.