wrongs stats on a column.. why?

Database
Enthusiast

wrongs stats on a column.. why?

Hello,

thank you in advance for your time.

After migration to 13.10 , we face one issue about stats.

There is a column which is char(16) and it contains values of :

000000001242546214...

000000001243256264...

0000000012431262...

and so on.....

The problem is the following,

We took stats on this column , but when we check the histograms , it was keeping only the first 8 bits , meaning, 00000000,and not

the whole value,this had a bad influence on how to do some joins and so on?

Has anyone faced a similar problem?Proposions?

Thank you very much.

2 REPLIES
Senior Apprentice

Re: wrongs stats on a column.. why?

Check the column definition, seems to be UNICODE:

Only the first 16 bytes of any stats (pre-TD14) will be stored and 8 chars UTF-16 need exactly 16 byte.

Btw, if it's a numeric string, why it's not a numeric datatype?

And if it's non-numeric, why it's always 8 leading zeroes?

Dieter

Enthusiast

Re: wrongs stats on a column.. why?

Xmm.... thanks for your answer....

It must be unicode,I will have to check it tomorrow.

For the other 2 questions, I have just joined on this project...so, I have to be ready to face and other cases like this.

Thank you very much for your quick answer.