----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/73298/#review222860 -----------------------------------------------------------
security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql Lines 1563 (patched) <https://reviews.apache.org/r/73298/#comment312018> Is index x_service_resource_IDX_guid needed, given x_service_res_UK_guid UNIQUE CONSTRAINT defined above, #1148? security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql Lines 1239 (patched) <https://reviews.apache.org/r/73298/#comment312017> Is index x_service_resource_IDX_guid needed, given x_service_res_UK_guid UNIQUE CONSTRAINT defined above, #1232? security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql Lines 1099 (patched) <https://reviews.apache.org/r/73298/#comment312016> Is index x_service_resource_IDX_guid needed, given x_service_res_UK_guid UNIQUE CONSTRAINT defined above, #1092? - Madhan Neethiraj On April 23, 2021, 10:22 p.m., Abhay Kulkarni wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/73298/ > ----------------------------------------------------------- > > (Updated April 23, 2021, 10:22 p.m.) > > > Review request for ranger, Madhan Neethiraj, Mehul Parikh, and Velmurugan > Periasamy. > > > Bugs: RANGER-3250 > https://issues.apache.org/jira/browse/RANGER-3250 > > > Repository: ranger > > > Description > ------- > > Tagged entities are persisted in a Relational database table. During ingress > of tagged entities, Ranger admin needs to look up this table. Indexing the > table on the columns that are used for look-up will speed up ingress rate. > > The columns 'resource_signature' and 'guid' in table 'x_service_resource' > need to have unique indexes built on them > > > Diffs > ----- > > security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql > 9d0cd9db2 > security-admin/db/mysql/patches/051-create-index-for-service-resource.sql > PRE-CREATION > security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql > 1904c6847 > security-admin/db/oracle/patches/051-create-index-for-service-resource.sql > PRE-CREATION > security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql > 51ef67b8f > > security-admin/db/postgres/patches/051-create-index-for-service-resource.sql > PRE-CREATION > > security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql > 97ddb5df3 > > security-admin/db/sqlanywhere/patches/051-create-index-for-service-resource.sql > PRE-CREATION > security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql > d15015009 > > security-admin/db/sqlserver/patches/052-create-index-for-service-resource.sql > PRE-CREATION > > > Diff: https://reviews.apache.org/r/73298/diff/1/ > > > Testing > ------- > > Passed unit tests > > > Thanks, > > Abhay Kulkarni > >
