Management Center search tables

The Management Center is a search intensive application, and you can tune your database to improve search performance if you know the tables and columns it uses.

The following chart shows the tables and columns used by Management Center search queries. If there are concerns with search performance, monitor these tables and take appropriate actions (such as cleaning the database, tuning database parameters, SQL profiling):

Table Column
CATGROUP IDENTIFIER
CATENTDESC NAME
CATENTRY PARTNUMBER
EMLMSG NAME
EMLMSG DESCRIPTION
EMSPOT NAME
EMSPOT DESCRIPTION
COLLATERAL NAME
MBRGRP MBRGRPNAME
PX_PROMOTION NAME
PX_PROMOTION CODE
DMACTIVITY NAME
DMACTIVITY DESCRIPTION
DMCAMPAIGN NAME
DMCAMPAIGN DESCRIPTION
PX_PROMOCD CODE