-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/68667/
-----------------------------------------------------------
Review request for ranger, Ankita Sinha, Don Bosco Durai, Colm O hEigeartaigh,
Gautam Borad, Madhan Neethiraj, pengjianhua, Ramesh Mani, Selvamohan Neethiraj,
sam rome, Venkat Ranganathan, Velmurugan Periasamy, and Qiang Zhang.
Bugs: RANGER-2205
https://issues.apache.org/jira/browse/RANGER-2205
Repository: ranger
Description
-------
When the number of records in the table 'x_trx_log' is 1000, the view
'vx_trx_log' query takes about 14.651 seconds.
Diffs
-----
security-admin/db/mysql/optimized/current/ranger_core_db_mysql.sql 3f23b0082
security-admin/db/mysql/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql
PRE-CREATION
security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql
bafdb9676
security-admin/db/oracle/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql
PRE-CREATION
security-admin/db/postgres/optimized/current/ranger_core_db_postgres.sql
2bc58acfe
security-admin/db/postgres/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql
PRE-CREATION
security-admin/db/sqlanywhere/optimized/current/ranger_core_db_sqlanywhere.sql
1b64eeac8
security-admin/db/sqlanywhere/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql
PRE-CREATION
security-admin/db/sqlserver/optimized/current/ranger_core_db_sqlserver.sql
4a216fed9
security-admin/db/sqlserver/patches/035-update-view-vx_trx_log-and-add-index-on-table-x_trx_log.sql
PRE-CREATION
Diff: https://reviews.apache.org/r/68667/diff/1/
Testing
-------
Thanks,
Xing Peng
