"select count_BIG(*) from dynamic_arg" faster for a large table


abe



"yjchong"
<db2udbdba-ezmlmshield-x43294312.[Email address protected] To:
om> "LazyDBA Discussion" <[Email address protected]
cc:
Subject: any alternative to count(*)
Monday January 31, 2005 01:28 AM






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