 |
 |
Archives of the TeradataForum
Message Posted: Mon, 25 Jun 2012 @ 10:32:16 GMT
| Subj: | | Re: How does Teradata work when merge join on MVC |
| |
| From: | | Vuyyuru_Ramaiah |
Anomy.Anom wrote:
| | how Teradata works when merge join (sort then join, right?) on MVC without decompression or merge join will not happen on MVC (?). | |
Yes, It sort then join ( tables data should be present on same amp). It works for compressed columns (MVC) as well. When the values are
comparing with one table to another table that time if it finds the compressed values (MVC) I think it decompress the values and perform the
comparison with other table values during joining.
| |
