Uploaded image for project: 'Kudu'
  1. Kudu
  2. KUDU-1100

Simple optimizations for pushed down PK ranges

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Private Beta
    • None
    • tablet
    • None

    Description

      Looking at a 'count' query on a very large table, it seems there are some very simple optimizations we could do. In particular, when we call PushdownRangeScanPredicate on a cfile set:

      • we don't need to call CreateKeyProjection – we can use the already-cached key schema
      • we should compare against the upper/lower bound of the cfile set, and if the range predicate is outside those ranges, not bother with a cfile seek

      Attachments

        Activity

          People

            tlipcon Todd Lipcon
            tlipcon Todd Lipcon
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: