Stats on partition on a no partitioned table

Database
Enthusiast

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.

3 REPLIES
Supporter

Re: Stats on partition on a no partitioned table

Enthusiast

Re: Stats on partition on a no partitioned table

Excellent Share!

Enthusiast

Re: Stats on partition on a no partitioned table

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.