count(*) giving "overflowed output/network buffer" error
Sep 14, 2010
A simple count(*) of the key_value table in the key_value example is giving the error:
Output from SQL stmt overflowed output/network buffer of 10mb. Try a "limit" clause or a stronger predicate.
This is through a stored procedure.
I know it is multi-partitioned query and performance will be impacted but surprised to see it hitting the buffer limits. Any work arounds to get to count(*) of huge tables ?
Thanks.
Output from SQL stmt overflowed output/network buffer of 10mb. Try a "limit" clause or a stronger predicate.
This is through a stored procedure.
I know it is multi-partitioned query and performance will be impacted but surprised to see it hitting the buffer limits. Any work arounds to get to count(*) of huge tables ?
Thanks.