Dear john

try using count(pkey column name)

Thanks

Thirumaran
----- Original Message -----
From: "yjchong" <db2udbdba-ezmlmshield-x43294312.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, January 31, 2005 11:58 AM
Subject: any alternative to count(*)


> Dear all,
>
> I have a query "select count(*) from dynamic_arg"
>
> It can be select count(*) from tblA
> or
> It can be select count(*) from tblB
>
> depend on run time in the application.
>
> My question: Is there any alternative to tune the about count(*) stmt?
>
> (I know the statistics will help, but these tables also involved high
> volume insert and update.... beside select query alone)
>
> Rgds,
> John
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


DB2 & UDB email list listserv db2-l LazyDBA home page