I am quite new here to Teradata...Can anyone help me onthe query.. I am looking out for skew factors for certain tables.I would like to know the query for the same and what would be the desired value or range which is acceptable.
Also i would like to know the query to see for what all columns of a table the stats is already collected and what is not collected. Appreciate your help ASAP.
You can have a look at this link(look till the end):
One way is you can have a look at dbc.statsv and verify too in the qrylog table or dbql
Hia thanks Raja..One more question..I am querying on a database to find the skeness of all tables..The result shows me including that of the stored procedures too and all stored procedures shows skeness of greate than 90..Is there something wrong?
Skew should not be considered important for any object smaller than a few data blocks per AMP. There is just not enough statistical distribution to get an even distribution. And skew for very small objects will not cause a noticeable performance issue. SPs are very small and each is purposely stored on a single AMP so they will always be skewed.