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

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