You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ranger.apache.org by "Peng Xing (JIRA)" <ji...@apache.org> on 2018/08/31 09:37:00 UTC

[jira] [Created] (RANGER-2205) Optimize view 'vx_trx_log' to improve query performance

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)