Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-1177 Cost-based query optimization
  3. PHOENIX-1322

Add documentation for UPDATE STATISTICS command

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.2.0, 3.2.0
    • Labels:
      None

      Description

      Four places need to be updated:

      • Add a new webpage and add the webpage to the Using menu (/site/source/src/site/site.xml). The webpage can talk about the new ANALYZE <table> command and give a couple of examples. It'd be good to document that stats are updated automatically during splits and compaction. Also, mention the new property values you added to control - number of bytes before guidepost put in, min time before another analyze may be done. Don't talk about implementation, though, other than the "why" we're doing this (i.e. to improve parallelization).
      • Add the new ANALYZE call with a short explanation to ./phoenix-docs/src/docsrc/help/phoenix.csv. This will cause it to appear here: http://phoenix.apache.org/language/index.html
      • Add an item at the top for Statistics Collection with a short explanation here: site/source/src/site/markdown/recent.md
      • Remove the first item from Cost-based Query Optimization, or change the font to strike through with a note that it's implemented in 3.2/4.2) here: site/source/src/site/markdown/roadmap.md

        Attachments

        1. Phoenix-1322_2.patch
          8 kB
          ramkrishna.s.vasudevan
        2. Phoenix-1322_1.patch
          7 kB
          ramkrishna.s.vasudevan

          Activity

            People

            • Assignee:
              ram_krish ramkrishna.s.vasudevan
              Reporter:
              jamestaylor James Taylor
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: