Wednesday, August 8, 2012

Distinct vs group by in Teradata .


Distinct vs group by in Teradata .

There is always a debate going on when finding out unique values in a given table.  The problem comes into picture when we use Group by or distinct to find it.
Both return same number of rows , but with some execute  time difference between them. Execution time is always a very important factor considering performance as one of the major factors is teradata warehouse.


No comments:

Post a Comment

Thank you :
- kareem