[
https://issues.apache.org/jira/browse/RANGER-2205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Peng Xing updated RANGER-2205:
------------------------------
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.
was:
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.
> 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
> Priority: Major
>
> When the number of records in the table 'x_trx_log' is 1000, the view
> 'vx_trx_log' query takes about 14.651 seconds.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
