Today i came across a weird scenario in Teradata.
One of my tables dbc.table_a was highly skewed with a skewfactor of 95.77 . I used the below query to check the skewfactor.
So after you changed the PI and re-loaded the table, are you sure that you checked the skew on the new table (the one with the fixed PI)?
That solved my problem. How are dbc.tablesize and dbc.tablesizev different?? Will have to find this out.
Thanks a lot!
Since TD12 all dbc-views without V/VX were legacy because they return CHAR(30) LATIN instead of the new VARCHAR(128) UNICODE, i.e. compatibilty views.
TD14.10 finally enabled long object names, so the old ones were deprecated.
There was enough time to get used to :)