Backoffice - View Database Itemtype Indexes

Question

How to view the DB column indexes in backoffice? Suppose I have added 3 indexes like this on a custom itemtype ( defined in *-items.xml) like this:

         <itemtype generate="true" code="Model"..>
            <attributes>
            .......
            </attributes>
            <indexes>
                <index name="column1Idx">
                       <key attribute="column1" />
                </index>
                <index name="column2Idx">
                    <key attribute="column2" />
                </index>
                <index name="compositeIdx">
                    <key attribute="column1" />
                    <key attribute="column2" />
                </index>                
            </indexes>
            </itemtype>

Note I'm using HSQL DB for development.

mkysoft · Accepted Answer · 2019-12-11T07:13:28.250

3

I didn't see any page for indexes in backoffice. But you can get them in hac. You can run below query in Console -> FlexibleSearch -> SQL Query tab.

SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS

For getting columns in index you can use below query:

SELECT * FROM INFORMATION_SCHEMA.STATISTICS

edited Dec 11 '19 at 07:13

answered Dec 07 '19 at 20:37

mkysoft

5,392
1
21
30

yeah. Backoffice doesn't have an option to see all the indexes. But the above query returns all table constraints, not the indexes. – BNR Dec 09 '19 at 21:28
You can filter by CONSTRAINT_TYPE. – mkysoft Dec 10 '19 at 10:51

Backoffice - View Database Itemtype Indexes

1 Answers1