To reduce workload in server, some features were introduced to move some jobs to client side. Row shipping is one of such features.
There are steps to process SQL, parsing -> optimzating -> Row Source generating -> result producting. In traditional mode, one job of Row Source gernerator is that choose the columns in SELECT clause from the rows return to client, which named Projection. We could find such information from output DBMS_XPLAN (10g later):
|
最新文章