diagnostic helpstats

Teradata Applications

diagnostic helpstats

Hi Dieter,

Please help in below issue.

diagnostic helpstats on  for session; 

It is giving zero processed. I would like to know SUPPORTDB.EMP_TEST on which column i have to use stats.

Please let me how to use the table in diagnostic helpstats on  for session;  statement.

Thanks in advance.

Regards,

Malli

4 REPLIES

Re: diagnostic helpstats

Hi,

I'm not Dieter, nor do i play him on TV, but would you be so kind as to clarify what you mean by "It is giving zero processed".   The query is returning zero rows, the diagnostic has no suggestions...?

Cheers

Re: diagnostic helpstats

Hi cheers,

How to apply diagnostic helpstats on  for session;  statement on table.

based on above statement i have to found on which columns stats need to define.

Please help on this.

Thanks in advance

Regards,

Malli

cbg
Teradata Employee

Re: diagnostic helpstats

First set the diagnostic and then issue the explain for a query which references your table in a join.

diagnostic helpstats on for session;

explain select ***;

The output will show recommended stats at the end of the explain.

Re: diagnostic helpstats

Hi cbg,

Thank you so much for your help.

Its successfully worked.

Regards,

malli