Is there a way to tell what index is used for a GlideRecord query?

David Hubbard
Tera Guru

We have a table with several indexes on it - in some client usage they are seeing slow performance - so, I am wondering if there is a way to tell - either directly from GlideRecord (or Meta) what indexes are used for the query? 

 

I am aware of the "Slow Queries" list,  but don't see any index available there to view.

12 REPLIES 12

I have found this and had a look in my dev environment - thanks - I am awaiting feedback from client on this.  

@David Hubbard 

 

Thanks for the update.

 

If my response helped to answer your query, please mark it helpful & accept the solution.

 

Thanks,

Bhuvan

Bert_c1
Kilo Patron

Try:

 

platform-performance/concept/index-suggestions documentation

 

Requires the 'com.glide.index_suggestion' plugin to be activated.