All Forums Database
eejimkos 73 posts Joined 01/12
18 Jul 2012
Stats on partition on a no partitioned table

Hello,

 

I would like to ask the following question.

 

When i take stats on partition column on a no partioned table,except from the gains, better result on sel count(*) - on ras / groth of a table ,

Are there any disadvantages?

Meaning,for the order and type of joins on other partitioned or no tables?

 

Thank you very much.

 

Dimitris.

ulrich 816 posts Joined 09/09
18 Jul 2012

I guess it is worth to read

http://developer.teradata.com/blog/carrie/2012/02/why-collect-partition-statistics-on-non-partitioned-tables

 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Qaisar Kiani 337 posts Joined 11/05
18 Jul 2012

Excellent Share!

eejimkos 73 posts Joined 01/12
19 Jul 2012

Hello,

 

thanks for replying.

 

I have already read this.

I was wondering mainly if there is a problem on joins and so on,

 

thank you very much , anyway,

 

Dimitris.

You must sign in to leave a comment.