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…