How to check database table index in hybris?

[Former Member]

I have created table indexes in items.xml file. After system update, I am unable to validate whether the indexes are actually created. Do anyone know how to check it?

[former_member615615]

You can use query to check whether indexes are applied or not.

select * from sys.indexes where name like 'Index_name_defined_in_items.xml'

[Former Member]

Hi,

For different database, they use different shemainfo tables. for hsqldb, if you want to check index creation of table, you use the following in hac sql query:

select * from INFORMATION_SCHEMA.SYSTEM_INDEXINFO where table_name='xxxxx'

for oracle database please check which system table describes index. https://docs.oracle.com/cd/E17952_01/mysql-5.0-en/statistics-table.html

[Former Member]

I have created an index for another attribute(not PK). It is Oracle database. Is there a way to check?

[VinayKumarS]

By default the indexes created on pk. If you want to implement indexes then you will have to explicitly mention in your items.xml. which database you are using??