Database indexing question

Unknown

Database indexing question

Unknown

hey I was curious if Decisions makes any indexes outside of a clustered index?
also can they make indexes?
[i]edited by frankgrimes on 11/16/2021[/i]

Unknown

Hey Frank,
Thats a good question. Decisions does actually Index on the backend in the DB. Additionally, Indexes can be added as you like.

Here are some explanations for the types of Indexes Decisions makes, and how it does so.

[b]Built-in objects (Account, Assignments, etc):[/b]
Decisions has some default Indexes that it creates on these Tables to speed up SQL operations. We have identified these as important based on profiling and tuning that has been done for the product. They are applied during installation.

[b]Folder Extensions[/b]:
Decisions will create indexes on Folder Extension objects to Index (1) the [b]primary key[/b] column, (2) the [b]parent folder id[/b] ([b]entity_folder_id[/b]) column, (3) the [b]extension_id[/b] column, and (4) the [b]extension_id_type[/b] column. They are created at the same time as the Database Table that stores the user-defined data.