> Is there a way I can scroll thru a particular index? For example: > > 1. Scroll forward/backward on a given set of records > 2. Start at position X > 3. Start at a record that matches a criteria
SQL is optimized to manipulate a set of records. It's much faster to execute "update mytable set mycolumn = 0 where mycondition = true" than to iterate through them and set them to zero individually. Can you do whatever it is with sql instead of code? The index is used transparently to locate rows faster. You don't iterate the index, you iterate the rows.
