Can i add db indexes to custom tables in suitecrm 7.10

Can i add db indexes to custom tables in suitecrm 7.10 ?
Do we need to use the extension folder or is there a different method for custom table ? Thanks

You can do it directly in the database.

I read an article online

https://journal.highlandsolutions.com/indexing-custom-tables-in-sugar-899789c2f4ca

which basically explains how to do it in the vardefs, but the QR & R has some bug and is unable to add the index, if it is on a custom table.

So they did it in code (you can grab that code and just run it as a custom entry-point, for example, no need to package it in Module builder).

Just choose whatever sounds easier for your case…