Cost-First or Sample-First: A Debate Over How Agent SQL Loops Handle Unknown Table Sizes

A drafting agent returns a query that reads fine: three joins, a GROUP BY, a date filter, an ORDER BY on the aggregate. Nothing in the SQL signals danger. The plan underneath it opens with a sequential scan over a table whose row count nobody on the call can state out loud, and the aggregate spills to disk before the first row comes back. That... Weiterlesen: Cost-First or Sample-First: A Debate Over How Agent SQL Loops Handle …