Queries should use indexes when appropriate

[joshua-spacetime]

Queries and subscriptions currently default to full table scans. We should incorporate index scans into query planning and utilize them when appropriate.