Indexing a custom entity for Quick Find

To add a custom entity to the Quick Find index, you must add new SQL Server indexes on the _Deleted and _UpdatedDate fields, and include the ID field on the index. You can enable the PAD option to reduce fragmentation of the index over time.

The following example adds an index for a custom entity named Project.

CREATE NONCLUSTERED INDEX [IDX_QUICKFIND_Proj_Deleted_UpdatedDate]
ON [dbo].[Project]
(
[Proj_Deleted] ASC,
[Proj_UpdatedDate] ASC
)
INCLUDE
(
[Proj_ProjectId]
)
WITH
(
PAD_INDEX = ON
)