changes addressed
@@ -1062,3 +1062,15 @@ CREATE INDEX IDX_ATS_TID
-- SP_TEMPLATE --
CREATE INDEX IDX_SP_TEMPLATE
ON SP_TEMPLATE (TENANT_ID, NAME);
+
+-- IDN_OAUTH_CONSUMER_APPS --
+CREATE INDEX IDX_OCA_UM_TID_UD_APN
+ ON IDN_OAUTH_CONSUMER_APPS(USERNAME,TENANT_ID,USER_DOMAIN, APP_NAME);
+
+-- IDX_SPI_APP --
+CREATE INDEX IDX_SPI_APP
+ ON SP_INBOUND_AUTH(APP_ID);
+
+-- IDN_OIDC_PROPERTY --
+CREATE INDEX IDX_IOP_TID_CK
+ ON IDN_OIDC_PROPERTY(TENANT_ID,CONSUMER_KEY);
