Skip to main content

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

  • May 3, 2016
  • 2 replies
  • 14 views

Rajzz
Forum|alt.badge.img+1
  • Participating Frequently

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

2 replies

eli_revach
Forum|alt.badge.img+2
  • Participating Frequently
  • May 3, 2016
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 .

Rajzz
Forum|alt.badge.img+1
  • Author
  • Participating Frequently
  • May 24, 2016

That make sense. thanks