>When you run select from command window you probably create filtered 'cursor'. Try to issue it with NOFILTER and you will see the difference. Also, what about SET DELETED setting and TAG on DELETED()?

Yes that's it ( no temporary table is created on disk )

>Again, there is no reason to use Remote or Local views returning thoousands of records. The whole idea of view is to return few records.

Yes, but a application is never made without exceptions

Tks