This may be a question related to product development as much as anything, unless there is a simple solution I have overlooked. As we approach our 1 year anniversary using LDSD Incident management globally, our database is growing and I have concerns about how the WebDesk query execution functions.
In Console - when a query is executed the user is first prompted to enter any of the execution variables, and then the query is processed. However in WebDesk all queries run first with no selection criteria, and then after the first result set is provided the user can put in selection criteria and execute a 2nd time.
Of course this is quite wasteful (and I will be embarrassed in we are the cause of this behavior - but still very thankful to identify how to change). - it causes frequent full table scans on a number of operational queries that our analyst use in the course of the day
Is it possible change the execution so that if mimics what console does? We do not use console at all - 100% of our analyst use Webdesk and I'm concerned that this will grow into a bigger problem.