Management Center search tables
The Management Center is a search intensive application, and you can tune the 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