----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/73298/#review222877 -----------------------------------------------------------
security-admin/db/sqlanywhere/patches/051-create-index-for-service-resource.sql Lines 16 (patched) <https://reviews.apache.org/r/73298/#comment312049> The UNIQUE index named "x_service_res_UK_guid" added in db-patch-016. Please reconsider. security-admin/db/sqlserver/patches/052-create-index-for-service-resource.sql Lines 27 (patched) <https://reviews.apache.org/r/73298/#comment312048> The UNIQUE nonclusterd index named "x_service_res_UK_guid" added in db-patch-016. Please reconsider. - Kishor Gollapalliwar On April 26, 2021, 1:24 p.m., Abhay Kulkarni wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/73298/ > ----------------------------------------------------------- > > (Updated April 26, 2021, 1:24 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/2/ > > > Testing > ------- > > Passed unit tests > > > Thanks, > > Abhay Kulkarni > >
