Archives of the TeradataForum
Message Posted: Thu, 24 Jun 2004 @ 07:53:16 GMT
Kambhoji, Naveen Ram Prasanna wrote :
I'm also looking at this issue, but can find no difference between the two constructs in terms of performance. Certainly would be interested in others' comments.
One suggestion I heard - albeit from an Oracle background - was that Count(1) used the statistics rather than from the table data, although I'm pretty sure that's nonsense.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|