Peng Xing created RANGER-2205:
---------------------------------
Summary: Optimize view 'vx_trx_log' to improve query performance
Key: RANGER-2205
URL: https://issues.apache.org/jira/browse/RANGER-2205
Project: Ranger
Issue Type: Bug
Components: admin
Affects Versions: master
Reporter: Peng Xing
Assignee: Peng Xing
When the number of records in the table 'x_trx_log' is 1000, the view
'vx_trx_log' query takes about 14.651 seconds.
Replace 'select in' with 'not exsit', after SQL optimization, the query is
about 0.048 second.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
