[
https://issues.apache.org/jira/browse/OOZIE-1717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16353710#comment-16353710
]
Peter Cseh commented on OOZIE-1717:
-----------------------------------
Test case seems unrelated
thanks for adding the tests! +1 for the amed-01 patch!
> 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, amend-OOZIE-1717-01.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)
