ServiceNow Troubleshooting · LessonBy Praveen T, ServiceNow Trainer, 9 yrs · Published · Updated · current release · fixes
ServiceNow Fixing slow queries
Diagnose and speed up slow lists and scripts.
Quick answer
Slowness usually traces back to the query. Check these.
Slowness usually traces back to the query. Check these.
- Review the Slow Query log for the offending statement.
- Ensure filtered fields are indexed.
- Avoid expensive dot-walking and calculated fields in list views.
- Replace record loops that count with GlideAggregate.
- Add
setLimit()and paginate large operations.
Quick check
+0 XPStreak ×0
Question 1 of 2
What speeds up filtering on a field?
Practise this on your own free instance.