Foros de discusión

Database Indexes are not created

SZ khan, modificado hace 12 años.

Database Indexes are not created

Regular Member Mensajes: 145 Fecha de incorporación: 31/10/09 Mensajes recientes
I am using Service Builder to create some entities. I see a folder called sql which contains tables.sql, indexes.sql etc. On deployment, the tables do get created but I don't see the indexes created on them. Is there a separate setting for creating indexes?

Thanks,
Sultee
thumbnail
Shagul Khajamohideen, modificado hace 12 años.

RE: Database Indexes are not created

Liferay Master Mensajes: 758 Fecha de incorporación: 27/09/07 Mensajes recientes
SZ khan:
I am using Service Builder to create some entities. I see a folder called sql which contains tables.sql, indexes.sql etc. On deployment, the tables do get created but I don't see the indexes created on them. Is there a separate setting for creating indexes?

Thanks,
Sultee


Usually the index is created on the finder columns when the build-service is run and the portlet is deployed. If you don't see error logs and the index in indexes.sql are not created on the tables, it may be a bug and probably check issues.liferay.com to see if this is reported/fixed.