Archives of the TeradataForum

Message Posted: Wed, 15 Jun 2011 @ 14:32:01 GMT


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

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

From:		Adithya K Bayyana

Hi,

Sukul Wrote:

From your reply i understand either of count(*) or count(1) is faster in >TD13 or above. But i didnt get which one exactly uses cylinder index.

I know that count(*) will use cylinder index. But I don't know about count(1).

Thanks,

Adithya


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

Archives

2011 Indexes

Last Modified: 15 Jun 2023