Hi @GiriSreerangam ,

How many rows are in the results table, and how large are these PDF documents? Genie’s UI and API may truncate large result sets, so it's possible you are seeing only a subset of matches even when the underlying SQL scans all rows.

As a quick follow-up, can you inspect the generated SQL in the response to see if Genie added any implicit LIMIT, filter, or top-k clause that reduces matches? If you find one, you can re-ask with explicit instructions or run the statement in the SQL editor to verify full results.