How to add index for new tables

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 .

alt text

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

0 votes

1 answers

1325 views

ANSWER



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.

1 votes