Options

what is statistics in vertica?? is it like a indexing in oracle?

RajzzRajzz
in General Discussion

what is statistics in vertica?? is it like a indexing in oracle? what is actually happen while i am doing analyze_statistics() ?

Comments

  • Options
    eli_revacheli_revach
    Hi,
    Statistics in a given time include info about your data , the info is mainly about the data distibution per colum and the amount of distinct value each column has . this info is being used by the optimizer helping him to used the correct execution plan(with regard to performence) for your data/query + the relevant projectios . when you analyze statistics , vertica will sample your data and build / update the statistics .
  • Options
    RajzzRajzz

    That make sense. thanks

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...