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...?
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
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.