Archives of the TeradataForum

Message Posted: Thu, 09 Jun 2011 @ 10:38:42 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Does Count(*) and count(1) has any difference?

From:		Barrow, Martin

If you are on TD13 or above, it will be fast as it takes the count from the cylinder index as opposed to scanning the table.


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2011 Indexes

Last Modified: 15 Jun 2023