Add Performance Indexes

Add the following performance indexes to your database. This should be incorporated into your existing performance tuning script (such as dbtune.sql)

The following indexes will optimize Dovetail Admin's performance:

Table

Column(s)

Index Name

Unique?

Comments

act_entry

focus_type, focus_lowid

focus_index

No

Enhances performance for a queue's activity log

See Also

Installing Dovetail Admin

Install the Dovetail SDK

Update the Clarify Schema

Set Configuration Items

Import the Data Files

Configure the Web Server

Edit the fc.env File

Test the Connection

Grant Permissions

Next

Main Admin Page

Add Performance Indexes