Archives of the TeradataForum
Message Posted: Wed, 22 Mar 2006 @ 20:30:17 GMT
Hmmm, don't know, how it's actually implemented...
Maybe just wait until the system is really busy and then:
.SESSION 10 .REPEAT 1000 insert into xxx select top 5001 * from large_table; select distinct * from xxx; ;-)
At least in the "Single AMP optimization" case it's probably always the same.
Unless it's utilizing "Sync Scan" :-(
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|