@megha_reddy
Pro member
Platform engineer focused on interview prep and GCP at scale.
Interview follow-up got me thinking, how do you actually implement this in production? Context: Incremental model full refresh strategy in prod Happy to share schema snippets or metrics if useful.
Added a btree on (status, created_at DESC). Query still does a seq scan on a 30M row table. status cardinality is low, only 4 values. Should this be a partial index instead?
© 2026 Lakebench, operated by Hunnurji Rao. Bengaluru, Karnataka, India.
No cluster. No install. Just the tab.
