>Can I use the Remote view to limit the records download form a huge database by using :
> recno()<=10
>or get next 10 records from index field?

If you are using Oracle as a Remote Database, you can say

WHERE rowid <=10

Bye
Jayesh