sa.lookup_tables.max_records_to_check

AI generated property description:

The ServiceNow property sa.lookup_tables.max_records_to_check sets the maximum number of records that a lookup query can evaluate when applied to tables listed in sa.lookup_tables.tables_for_limited_query. The default value is 100, meaning that lookup queries stop processing after checking 100 records. Administrators can raise this value to improve query completeness or lower it to reduce load and improve system performance. Increasing the threshold may provide more accurate results but risks higher query times and potential performance degradation, while decreasing it improves efficiency at the cost of potentially missing valid matches. This property is typically configured in environments where lookup query performance needs to be balanced against accuracy, especially when handling large datasets or frequently queried tables.

Source