Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-4887

Query cost estimation: ordering by an unindexed property not reflected

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.2
    • Fix Version/s: 1.7.12, 1.8.0
    • Component/s: query
    • Labels:
      None

      Description

      A query that orders by an unindexed property seems to have no effect on the cost estimation, compared to the same query without the order by, although it has a big impact on the execution performance for larger results/indexes.

        Attachments

        Issue Links

          Activity

            People

            • Assignee:
              thomasm Thomas Mueller
              Reporter:
              alexander.klimetschek Alexander Klimetschek

              Dates

              • Created:
                Updated:
                Resolved:

                Agile

                  Issue deployment