SQLite Indexing

Hi There!

I’m using Cockpit with SQLite storage. Does Cockpit support indexing?

I found this tutorial for adding an index to SQLite
https://community.esri.com/groups/appstudio/blog/2018/08/21/working-with-json-in-sqlite-databases

If Cockpit support indexing, how to use the index? is it automatically used on API call?