Level 10 - MasterDebugging Questionsm3 governance security cost control
Debug Runaway Full-Table Scan in Compliance Job
Compliance job times out. Fix query shape: SELECT * FROM audit_logs WHERE DATE(event_ts) = CURRENT_DATE AND actor_email LIKE '%@example.com';
Schema Context
audit_logs(event_id, actor_email, action, event_ts), index(event_ts, actor_email)