How to add index for new tables

[atul_]

I want to add some new indexes to my custom tables that are APPLICABILITY that is created by the a complex type schema as shown in image below .

Is it possible to do using the default-repository-config.xml ?

Or we will have to create the indexes at the SQL level?

Thanks Atul

[Florent_Guillau]

Adding a explicit index on a SQL column (presumably so that searches on it are faster) are something you must do directly at the SQL level.