Query tuning help by highlighting or coloring indexed fields in query rule editor
I came across many queries in Collections and found that IT-Pros use sometime fileds in their (collection) queries which are not indexed - which has a negative effect on query and collection performance. I would wish that we display the indexed values in bold or colour so you will be aware of the data which gives you better performance. In a second step we may be able to provide an alternative field if available in another attribute class.
Dustin Hedges commented
I would love to see this added into Management Insights if it cannot be done directly within the query editor.
Jeff Carreon commented
This would really help large organizations with large hierarchies for scalability. Most admin console users are NOT aware of indexed vs non-indexed fields. Therefore, performance suffers when many collections are created with non-indexed fields. Please have a way for admins to easily make distinctions between indexed and non-indexed tables.
I share this idea