Skip to Content
avatar image
Former Member

DISTINCT_VALUES Parameter default to GROUPBY

We are looking for a way to default a number of global Universe parameters specifically DISTINCT_VALUES automatically set to GROUPBY for each new Universe generated for a given Teradata DBMS. I reviewed the PRM files for the DBMS in question, but I didn't see the DISTINCT_VALUES listing in the Parameters file.

Any ideas would be greatly appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 30, 2010 at 10:35 PM

    You are asking for a way to default this permanently, rather than changing it inside of Designer itself?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I agree that the parameter change is extremely easy to do, but again its not getting done. We are getting a push by upper level management to provide hard defaults that make sense. GROUPBY is one of several that we are having concerns about. We don't have Teradata 13 and won't have for quite a long time and it won't handle some of the other defaults we need to define as well.

      Also, we have always been aware that Distinct performs better on small tables than Group By, but the positive benefit is very minor as the additional processing incurred by Group By method for small tables is minute as the table is small. Distinct on very large tables has been extremely bad for us, hence this inquiry on changing the defaults.