"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message
news:7R***************@newssvr26.news.prodigy.com. ..
Can someone help me to confirm -
From the access plan tree of a query, if one table is referred (TABLE
SCAN) three times. Does that mean this table was scanned (either from disk or
bufferpool) three times during runtime?
TIA
FRX
That is certainly possible, especially if there is a subselect. It might
also indicate intra-partition or inter-partition parallelism. But it is hard
to know exactly what you are referring to without seeing the explain output.
All data is accessed by applications from the bufferpool. If the page which
contains the needed row is not in the bufferpool, DB2 puts it in the
bufferpool for access by the application. The explain does not take into
consideration any physical I/O to put needed pages in the bufferpool if they
are not already there. However, the explain will indicate prefetch activity,
which is attempt by DB2 to place pages in the bufferpool before they are
asked for by the application.