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

Posted to dev@oozie.apache.org by "Hadoop QA (JIRA)" <ji...@apache.org> on 2018/02/06 00:16:00 UTC

[jira] [Commented] (OOZIE-1717) Add indexes to speed up db queries

    [ https://issues.apache.org/jira/browse/OOZIE-1717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16353131#comment-16353131 ] 

Hadoop QA commented on OOZIE-1717:
----------------------------------

PreCommit-OOZIE-Build started


> Add indexes to speed up db queries
> ----------------------------------
>
>                 Key: OOZIE-1717
>                 URL: https://issues.apache.org/jira/browse/OOZIE-1717
>             Project: Oozie
>          Issue Type: Bug
>            Reporter: Purshotam Shah
>            Assignee: Attila Sasvari
>            Priority: Minor
>             Fix For: trunk
>
>         Attachments: OOZIE-1717-00.patch, OOZIE-1717-002.patch, OOZIE-1717-003.patch, OOZIE-1717-004.patch, OOZIE-1717-01.patch, amend-OOZIE-1717-00.patch
>
>
> User_name is one of the frequently used filter. Adding index should avoid  full db scan.
> Index need to be done for BUNDLE_JOBS,COORD_JOBS and WF_JOBS.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)