Sorting Oracle tables

Hi

Can anyone tell me how to resolve this problem?

I use VB5 and ODBC to access to an Oracle DB under Windows NT Server.

I have a table with a column called product_id. This column is used for identify the products in my app.
Well, i need to access to one row using a select.... where product_id = 1111, and i need to movenext and moveprevious over this table, in order to obtain the next an previous product row ordered bye product_id. I can make this using "order by product_id", but the query is too slow. if i don't use the "order by product_id" clause, the rows are not sorted in my query.
Can i make this table sorted bye product_id, and obtain the rows ordered by product_id when i call movenext and moveprevious method? In this case, i not need to use the "order by product_id" clause and i gain much speed in query. In the same way, how to, when i add a row, this row is added in the sorted position?
please, e-mail me at cgg_at_lcg.servicom.es thanks very much
regards
cgg '97 Received on Sun Aug 31 1997 - 00:00:00 CDT