Oracle Indexes

Ensure that the following Oracle indexes are created for the best performance of cacheless search:

• PVARIANTEXPRESSION(POPERATOR,PFORMULA_STATE)
• PSOccurrenceNotes PPNOTE_TEXTS(UPPER(PVALU_0))
• PPSOCCURRENCE(RCHILD_ITEMU,ROCC_THREADU)
• PPSOCCURRENCE(RALTERNATE_ETC_REFU,ROCC_THREADU)
• PITEMREVISION(PUID,RITEMS_TAGU)
• PPOM_APPLICATION_OBJECT(ROWNING_GROUPU,PUID)
• PEXPRESSIONS(PUID)
• PVARIANTEXPRESSION(POPERATOR, PUID)

Related Topics

• Teamcenter Basics
• Dispatcher ─ Deployment and Administration
• Structure Management on Rich Client ─ Usage