Conceptselective predicate
Selective Predicate
A filter condition in SQL used to narrow a result set from an entire table down to a small number of rows. The query planner uses its estimated returned row count to choose between an index scan and a full table scan.
Timeline (last 90 days)
Oct 13
When an Agent drafts SQL against a live catalog without placement rules, it easily omits selective predicates, causing the query planner to choose large-range scans, which in turn extends lock hold times and intensifies I/O contention.
Unverified50%