I have a procedure which creates dynamic SQL statements to collect stats on table after its loaded.
The procedure gathers stats from two tables DBC.COLUMNSTATS & DBC.MULTICOLUMNSTATS.
Now this procedure works fine in TD 13.10 but fails in TD 14 saying dbc.COLUMNSTATS does not exist.
Are these table Deprecated in TD 14? Do we have any replacement?
See the Data Dictionary manual for TD14. Stats information is significantly changed.
DBC.ColumnStatsV, DBC.IndexStatsV, DBC.MultiColumnStatsV exist but are likely not direct replacement for your application.
Yes it seems I will have to change my application code in order to use these views.
I have posted the same query to Diether's blog as well.
With the TD14 views, rows will be only returned when stats are present, so there is no need for the NOT NULL filter in the above queries.
(Alternatively, if you were interested in finding indexes without stats, you might query dbc.IndicesV WHERE NOT EXISTS corresponding dbc.IndexStatsV.)
Not sure I understand your second question. There is a view named dbc.MultiColumnStatsV in both TD14 and TD13.10, but the definitions are quite different. TD14 does not have a dbc.MultiColumnStats (without the V).