Archives of the TeradataForum
Message Posted: Thu, 14 Dec 2006 @ 17:26:16 GMT
Subj: | | Re: Avoiding distinct in grouping |
|
From: | | Victor Sokovin |
| I finally got my answer myself. | |
Yes but will the solution be faster than the DISTINCT?
If not you could look up similar threads in the archives. There should be examples showing that DISTINCT can sometimes be replaced by GROUP BY.
Depending on the data distribution (and the database release) this may help.
OLAP functions might be useful to explore as well.
The optimal method depends on your specific data and its distribution so some testing is always a good idea.
Regards,
Victor
|