How many SQL queries are executed during a 30-day historical collection if all 10 indicators in the historical collection share the same daily indicator source?
Platform Analytics optimizes historical data collection by executing one query per indicator source per day, regardless of how many indicators reference that source. If 10 indicators share the same daily indicator source, the system executes only one SQL query per day, not one per indicator.
Over a 30-day historical collection period, this results in 30 SQL queries total. This optimization significantly reduces database load and improves performance. ServiceNow documentation explicitly highlights this behavior as a best-practice advantage of reusing indicator sources. Therefore, option C is the correct and documented answer.
Owen
49 minutes agoJade
5 days agoGlennis
10 days agoMerlyn
16 days agoAleta
21 days agoRosendo
26 days agoTeddy
1 month ago