Re: Help on rowid (SE 5.0)

javi@psi.ernet.in (javeed anwar t) writes: >Dear Informix Friends, >In INFOMIX SE 5.0 : >Whenever I do a partial scan or total scan on a table, whether it will also >scan the rowid's for which there are no records and degrade the performance? >I would also like to know how the rowid behaves when a record is deleted >from the table. >Thanx in Advance >------------------------------------------------------------------------- >Javeed Anwar T e-mail : javi@psi.ernet.in >PSI Data Systems Phone : (91 80) 5585726 >19,Primrose Road >Bangalore 560025 >INDIA >------------------------------------------------------------------------- From the Informix Reference Manual: If a row is deleted from the table, its ROWID can be assigned to a new row. You should not attribute chronological or other significance to the sequential values of ROWID. --------- Bernard Speekenbrink bernards@xs4all.nl ---------