Archives of the TeradataForum

Message Posted: Wed, 11 Dec 2002 @ 10:39:36 GMT

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

How is it that a count(*) may take a long time to return a value but delete * will act immediately and tell you how many rows there were?

Are there different counting mechanisms at work here and, if so, why doesn't count use the same mechanism as the delete?

Bill

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