Query based on rowid in Oracle
Posted on 2003-03-06
I have table with 3 million records. I am using ado with vb to get the data from the oracle database. I wish to limit the records returned by the query to 200 so that it takes less time for the initial query. When the user scolls down the I will get the other records. Can I base my query on the rowid?. Like
select table.*,rowid from test where rownum <201 will be my initial query to get the 200 records
select table.*,rowid from test where rownum <201 and rowid >prevrowid
will this be ok? or is there any other way I can do it.