Archives of the TeradataForum
Message Posted: Fri, 08 Jul 2005 @ 08:43:04 GMT
<-- Anonymously Posted: Friday, July 08, 2005 04:16 -->
I am trying to run the below given queries on a 2.5 TB call table A with 7 Billion rows.
I want to know whether the second query has any serious performance impact in terms of delaying the results and using more spool.
Select Cd, Id from A; select Case when (Cd = 'S') Then 'SEC' When (Cd = 'X') Then 'ABC' When (Cd = 'Y') Then 'XYZABC' Else NULL End , Id From A.
The table is really huge and it is partitioned on Date.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|