Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Xcenter (on-prem) new function based indexes added in v21

in Retail Point-of-Service Solutions (MOSC) 5 commentsAnswered

Xcenter v21.0.2

Comparing with Xcenter 17 database, our team has noticed that Xcenter 21.0.2 has added function-based index to its tables.

For example, for TRN_TRANS table, a function-based index was added to include UPPER("TRANS_STATCODE") & UPPER("TRANS_TYPCODE")

Here's a list of tables that we noticed where function (i.e UPPER) was added to the index:

COM_ADDRESS

COM_REPORT_DATA

COM_REPORT_LOOKUP

COM_TRANSLATIONS

CRM_PARTY

CRM_PARTY_EMAIL

CRM_PARTY_ID_XREF

CRM_PARTY_LOCALE_INFORMATION

CRM_PARTY_TELEPHONE

CTL_EVENT_LOG

ITM_ITEM

ITM_ITEM_CROSS_REFERENCE

ITM_ITEM_DIMENSION_TYPE

ITM_ITEM_DIMENSION_VALUE

ITM_MERCH_HIERARCHY

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center