Dear DB2 folks,

I obtain the same result after run the simple "select count(*)
from tbl1" or "select count(1) from tbl1"
in the Visual Access Plan, it returns the same timeron.

Is there any better alternative to improve the query performance?

Rgds,
John

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