Database Indexing

Frequently Asked Questions

Below are some of the most frequently asked questions with Database Indexing.

What type of indexing does Decisions do to the database in the background? Does Decisions make any indexes outside the clustered index established on table creation?

Built-in objects (Account, Assignments, etc.) and Folder Extensions.

What does Decisions index on the Folder Extension?

Decisions will create indexes on Folder Extension objects to index the primary key column, the parent folder id (entity_folder_id) column, the extension_id column, and the extension_id_type column.

Why are built-in objects indexed?

These were identified as important based on profiling and tuning done for the product. Decisions has some default indexes that it creates on these tables to speed up SQL operations.

When does the indexing happen?

Built-in objects are indexed during installation, and Folder extensions are created simultaneously in the database table that stores the user-defined data.

Is there a way to disable the auto-creation of indexes for Folder Extension Objects?

Currently, there is no way to disable the auto-creation of indexes for Folder Extension objects.

Can indexes be added?

Yes. Indexes can be added.