indexer: Remove temporary table usage for read-only queries

Symmetrically to #1073 (closed), we need to stop using temporary table for reading data.

---

Migrated from T1095 (view on Phabricator)