Archives of the TeradataForum
Message Posted: Wed, 11 Dec 2002 @ 10:39:36 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|