piso演算法

⑴ simple演算法和piso演算法的異同

--單獨遠程語句消耗時間 00: 00: 00.06
SQL> SELECT * FROM v_remote WHERE object_id=11;
已選擇32行。
已用時間: 00: 00: 00.06
執行計劃
----------------------------------------------------------
Plan hash value: 1788691278
--------------------------------------------------------------
| Id | Operation | Name | Cost (%CPU)| Inst |IN-OUT|
--------------------------------------------------------------
| 0 | SELECT STATEMENT | | 0 (0)| | |
| 1 | REMOTE | | | REMOTE | R->S |
--------------------------------------------------------------

Remote SQL Information (identified by operation id):
----------------------------------------------------