We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


what is statistics in vertica?? is it like a indexing in oracle? — Vertica Forum

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

  • 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 .
  • 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 ...