How do we create composite index on multiple columns in Frappe/Erpnext. For individual fields in the Doctype, we can create the index. However, if we want to create a composite index based on more than one field, how do we create the same?
It will need to be directly on the database
Also, you can use the hook after_install to create the hook when the app is installed.
Also, the index can be created using patches are skipped when they you install the app, so that’s why after_install is also needed
Thank you… We can even use after_migrate hook it seems… Will that be fine?