IBM Support

How do I diagnose slow searches and create database indexes for faster searches?

Technical Blog Post


Abstract

How do I diagnose slow searches and create database indexes for faster searches?

Body

The IBM FileNet P8 Content Engine Searches technote contains detailed information on how the Content Engine performs database searches and discusses best practices for writing a search to use indexes, the types of tools necessary to identify slow queries, techniques to validate that the required indexes are used, and additional causes of indexes not being used in a database query.  This technote is well worth a look

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSNVNV","label":"FileNet Content Manager"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

UID

ibm11280470