[ https://issues.apache.org/jira/browse/OOZIE-1717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Attila Sasvari updated OOZIE-1717: ---------------------------------- Attachment: amend-OOZIE-1717-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)