Adding indexing to the database code for future api manager's carbon-kernel component

[riyazathali]

Description:
Here is a suggestion to ship the following indexes with the future release of APIM. Currently, these indexes are used to improve database query performance.

CREATE UNIQUE INDEX "UCSD_APIM"."USER_DB_UM_USER" ON "USER_DB "."UM_USER"
("UM_USER_NAME" ASC,
"UM_TENANT_ID" ASC)
INCLUDE ("UM_ID" )

COLLECT SAMPLED DETAILED STATISTICS
COMPRESS NO ALLOW REVERSE SCANS;

CREATE INDEX "UCSD_APIM"."USER_DB_UM_USER_ATTRIBUTE" ON "USER_DB "."UM_USER_ATTRIBUTE"
("UM_USER_ID" ASC,
"UM_ATTR_NAME" ASC,
"UM_TENANT_ID" ASC,
"UM_PROFILE_ID" ASC,
"UM_ATTR_VALUE" ASC)

COLLECT SAMPLED DETAILED STATISTICS
COMPRESS NO ALLOW REVERSE SCANS;

Affected Product Version:
APIM 2.6.0