I have a dashboard where one of the panels is generated from a |loadjob command which produces a table. This part works as normal. Now, I need to add an extra column onto the panel's table and as a result, I need to incorporate another index onto the panel's query. As result, the panel's query has both the |loadjob and also an appendcols piece that searches an index. The extra clause is as follows:
It probably slows down because you are doing an additional search - if you are using load job for the first part of the search, have you considered using load job for the appendcols part of the search too?