Help on rowid (SE 5.0) - Reminder

Dear Informix Friends, I had earlier posted a query regarding the behaviour of rowid in INFORMIX SE 5.0. I feel that was not descriptive enough. May be because of that I have not received replies. I shall elaborate on that. The problem is like this: I have got a table with large number of records (say 2 lakhs), which was being inserted into the table over a period of time. After the creation of table, only insert operation was performed on the table (ie: update and delete operations are not done). This will result in the records having rowid's from 1 to 200000. Now, I delete 1 lakh records based on certain condition so that the order of rowid's are now not in any order (ie: certain rowid's in between 1 and 200000 are lost). 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? ------------------------------------------------------------------------- Javeed Anwar T e-mail : javi@psi.ernet.in PSI Data Systems Phone : (91 80) 5585726 19,Primrose Road Bangalore 560025 INDIA -------------------------------------------------------------------------