Slow query from job "Service Analytics RCA for Change Request"Issue Slow queries from job "Service Analytics RCA for Change Request" impacting instance performance Cause- "Service Analytics RCA for Change Request" generated a bad query which returned large amount of results. Ex: 2021-01-20 08:49:04 (139) worker.6 worker.6 txid=1c84b5861b75 WARNING *** WARNING *** Large Table: Table handling an extremely large result set: 104433Query that got us here is: TABLENAME = task_ci ENCODED_QUERY = ci_itemIN4b5a542bdb0dc700b3613caf9d96197b,f893a4f1dbbddf001ddee3a84b961914^sys_class_name=change_request - Notice the query is on "task_ci" table with filtering on "sys_class_name" field. There are no "sys_class_name" field on this table therefore the filter never worked and large result was return. The filter was supposed to be on "task.sys_class_name" instead. - The result are further used in another query which is slow caused unnecessary DB overhead. Ex: 2021-01-20 09:53:41 (346) worker.6 worker.6 txid=1c84b5861b75 Time: 0:00:00.186 id: honeywell_1[glide.22] (connpid=6911959) for: SELECT task0.`sys_id` FROM task task0 WHERE task0.`sys_class_name` IN ('change_request','change_request_imac') AND (task0.`sys_id` IN ('2598fd331bedac98e1cb0d47dc4bcb71' , 'fa2416dd1b292cd46f34a60abc4bcb87' , ... , <lots more sysids>))Resolution- This will be addressed in PRB1460159 - Temporary workaround is to disable the Job. This Job is a new feature on Paris and shouldn't have impact on any existing features