How to troubleshoot when a customer complains the data steward application is very slow - including taking more than 10 seconds to open a BOV, taking more than 1 minute to check out records in a duplicate management workflow, etc.

Linked to Support cases: SUPPORT-2961, SUPPORT-3212, SUPPORT-3255 

Slow BOVs/Navigating through the data

...

1. Under Preferences → Data Stewardship, uncheck Predictable Pagination. 
2. Open the BOV. Under More, look at Customized Sort. Are there any attributes sorted? If yes, remove all attributes. This should increase speed of application. The more attributes sorted, the longer the BOV will take because Oracle is taking a very long time to sort the attributes when the BOV opens.
3. No attributes under customized sort? What about Customized Sort defined in the Workbench under the BOV configuration? If Customized Sort is turned on and there's a sort expression, turn off Customized Sort and performance should be improved. 
4. If there's still bad performance or NPE when opening BOVs, sort preferences might have a problem. Go to Preferences, Under Filters restore defaults. Under Sort Criteria, also restore to defaults. Getting rid of Sort and sort preferences usually solves the problem. What can happen is a user who is waiting a long time for a BOV to open can get impatient and click the refresh button on the browser. This causes the preferences to get in a weird place and resetting them should fix any exceptions.

Dupes Mgmt Workflow takes a long time 

Step 1: Troubleshooting in Semarchy

...

Probably have Calculate statistics turned on. Check out this Confluence article for details.