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.

You must have the pxAccessSearchLP privilege to access the Search landing page.
Note: Multitenancy is not supported.
  1. Click Designer Studio > System > Settings > Search.
  2. In the Security section, click Customize full text search.
  3. Click For specified properties. You cannot create a dedicated index if this field is not selected.
  4. From the Records Explorer, click System > Custom Search Properties.
  5. Double-click the Custom Search Property instance that you want to use as a dedicated index.
  6. Click Use dedicated index.
    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.