You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@oozie.apache.org by "Rohini Palaniswamy (JIRA)" <ji...@apache.org> on 2014/05/07 01:58:15 UTC
[jira] [Commented] (OOZIE-1717) Index user_name column
[ https://issues.apache.org/jira/browse/OOZIE-1717?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13991369#comment-13991369 ]
Rohini Palaniswamy commented on OOZIE-1717:
-------------------------------------------
[~shwethags],
Remember you mentioning about some other columns to index in another jira. Could not find it now. Can you list those and it can be addressed together in this jira.
> Index user_name column
> ----------------------
>
> Key: OOZIE-1717
> URL: https://issues.apache.org/jira/browse/OOZIE-1717
> Project: Oozie
> Issue Type: Bug
> Reporter: Purshotam Shah
> Priority: Minor
>
> 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
(v6.2#6252)