[ https://issues.apache.org/jira/browse/OOZIE-1717?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Attila Sasvari updated OOZIE-1717: ---------------------------------- Summary: Add indexes to speed up db queries (was: Index user_name column) > 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 > Attachments: OOZIE-1717-00.patch, OOZIE-1717-002.patch, > OOZIE-1717-003.patch, OOZIE-1717-004.patch, 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)