-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/73298/
-----------------------------------------------------------
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
