https://connect.hyland.com/t5/nuxeo-forum/how-to-add-index-for-new-tables/m-p/317857#M4858 <P>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 .</P> <P><IMG src="https://connect.hyland.com/upfiles/table_schemapng.png" alt="alt text" /></P> <P>Is it possible to do using the default-repository-config.xml ?</P> <P>Or we will have to create the indexes at the SQL level?</P> <P>Thanks Atul</P> Thu, 30 Oct 2014 09:42:02 GMT atul_ 2014-10-30T09:42:02Z https://connect.hyland.com/t5/nuxeo-forum/how-to-add-index-for-new-tables/m-p/317857#M4858 <P>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 .</P> <P><IMG src="https://connect.hyland.com/upfiles/table_schemapng.png" alt="alt text" /></P> <P>Is it possible to do using the default-repository-config.xml ?</P> <P>Or we will have to create the indexes at the SQL level?</P> <P>Thanks Atul</P> Thu, 30 Oct 2014 09:42:02 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-add-index-for-new-tables/m-p/317857#M4858 atul_ 2014-10-30T09:42:02Z https://connect.hyland.com/t5/nuxeo-forum/how-to-add-index-for-new-tables/m-p/317858#M4859 <P>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.</P> Tue, 04 Nov 2014 13:53:47 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-add-index-for-new-tables/m-p/317858#M4859 Florent_Guillau 2014-11-04T13:53:47Z