0votes
0answers
0joined
Agent-written SQL queries table-scan the largest tables despite existing indexes
A text-to-SQL agent generates queries that run but ignore obvious indexes — doing full scans on the 200M-row events table when a user-id index would answer the query in <50ms. Showing the schema DDL (including indexes) in the prompt helps marginally.