Add index for the "startdate" column for the worklog table

XMLWordPrintable

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      Currently the timesheet gadget on JIRA is running the following query to pick up the data: 

      SELECT ID, issueid, AUTHOR, grouplevel, rolelevel, worklogbody, CREATED, UPDATEAUTHOR, UPDATED, STARTDATE, timeworked FROM worklog WHERE (STARTDATE >=  'XXXX ) AND (STARTDATE <  XXXXX' );

      since there is not index for the column startdate, this query need to make a full table scan with the condition as in the execution plan. Having an index on that column will dramatically improve the query execution time.

            Assignee:
            Unassigned
            Reporter:
            Yilin (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: