Issue

When trying to open the Workflow Inventory page, the page times out.

Resolution

The Workflow inventory page is timing out because the workflows table is not being indexed. Please run the below script on all Nintex content databases in the farm.

CREATE NONCLUSTERED INDEX [IDX_StartTime_WorkflowID] ON [dbo].[WorkflowInstance] 

( 

[WorkflowID] ASC 

) 

INCLUDE ([StartTime]);