## Background The system_notes resolver currently builds lookup arrays for each ClickHouse query (paths, source_ids, project_ids, iids). With !1557 these are chunked to avoid URI overflow, but each chunk still sends the raw param arrays. ## Proposal Use ClickHouse dictionaries for the resolver lookups, similar to the approach in !1521. This would avoid sending large param arrays entirely and speed up the resolve step for dense namespaces. <!-- Use this section to explain the feature and how it will work. It can be helpful to add technical details, design proposals, and links to related epics or issues. --> Related to !1557