Creating dedicated indexes

Dedicated indexes are property type-aware, per-class indexes that return the data type of each returned property. Default indexes are typeless, that is, all properties are of type string. Dedicated indexes let you execute queries with filters, date calculations, and aggregations directly in the query. Dedicated indexes are displayed on the Search landing page in the Dedicated indexes section.

Before you begin:  To access the Search landing page, you must have the pxAccessSearchLP privilege, which is included in the PegaRULES:SysAdm4 role.
  1. In the header of Dev Studio, click Configure > System > Settings > Search.
  2. In the Security section, click Customize full text search.
  3. Select the For specified properties check box. You cannot create a dedicated index if this check box is not selected.
  4. In the navigation panel, click Records > SysAdmin > Custom Search Properties.
  5. Double-click the custom search property instance that you want to use as a dedicated index.
  6. Select the Use dedicated index check box.
    Note: After you create the dedicated index, you cannot clear Use dedicated index. You must delete the index on the Search landing page.
  7. Optional: In the Disable data types for dedicated index column, select the check box for any properties that you want to be returned as string. You cannot filter or aggregate these fields based on their actual data type.
  8. Click Save.
  9. Click Create dedicated index to create a dedicated index for this class.
    The message "Currently using index <index>" is displayed under the Use dedicated index field along with the status of the index.