sa.lookup_tables.max_records_to_checkThe sa.lookup_tables.max_records_to_check property sets the maximum number of records to consider during a lookup query. Admins should review this setting to optimize performance and ensure efficient data retrieval, especially in large datasets.
The answers below summarize the purpose, scope, default effect, and review scenarios for this property.
| What does it do? | This property limits the number of records checked in lookup queries to enhance performance and reduce load times. |
|---|---|
| What area does it affect? | Lookup Tables |
| What does the default mean? | The default value is "100", which sets the baseline numeric behavior for this property. |
| When should you review it? | Review this property when optimizing query performance or adjusting data retrieval limits. |
Raw metadata from the property record.
| Property name | sa.lookup_tables.max_records_to_check |
|---|---|
| Sys ID | c0c0411277d6421036bc79ba2c5a991d |
| Type | integer |
| Application | Global |
| Default value | 100 |
| Description | Numbers of records to limit lookup query, The default value is 100. (Part of 'sa.lookup_tables.tables_for_limited_query') |
| Updated | 2024-05-27 02:01:23 |