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

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.2.0, 3.2.0
    • None
    • 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_1.patch
          7 kB
          ramkrishna.s.vasudevan
        2. Phoenix-1322_2.patch
          8 kB
          ramkrishna.s.vasudevan

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: