0 votes

From Efficy 2014 R6640 in the DBEditor there is a new tool to add compute additional indexes to speed-up list queries, also for custom entities.

Is it about Database Native Indexes? Where is it? How this is working?

Can we have more information of indexes which have been put in place to improve search performance?

asked in Utilities by (1.8k points)

1 Answer

+1 vote

R&D answer:

The little tool is accessible via the “Tools” menu added to the DbEditor.

Once you are connected to a database, just click on the menu item and a window will display the SQL needed to create the missing indexes.

It is indeed about the DB native indexes.

There has been quite a few indexes created for Belfius overall, not only in search but in entity lists as well, except for the Belfius specific ones they are all available in standard in the SYS_INDEXES table.

If you are wondering exactly which ones are new compared to an older version at a client, the easiest is to compare the XML structure files with SVN diff.

answered by (1.8k points)
1,167 questions
1,425 answers
1,717 comments
325 users