You have to SEEK and use the REST scope to manually optimize NoSQL-style of commands. SQL command optimization is handled by the SQL optimizer.

Performing sequential scans in a LAN is bad practice and is not recommended.