FILTER 优化

 PLAN_TABLE_OUTPUT
Plan hash value: 2272901224
 
------------------------------------------------------------------------------------------------
| Id  | Operation            | Name                    | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT     |                         |   708 | 30444 |  1521   (2)| 00:00:01 |
|*  1 |  FILTER              |                         |       |       |            |          |
|   2 |   VIEW               |                         | 14159 |   594K|  1519   (2)| 00:00:01 |
|   3 |    SORT UNIQUE       |                         | 14159 |   746K|  1519   (2)| 00:00:01 |
|*  4 |     TABLE ACCESS FULL| BTOP_TELLER_TELLERLOGIN | 14159 |   746K|  1517   (1)| 00:00:01 |
|*  5 |   TABLE ACCESS FULL  | BTOP_TELLER_TELLERLOGIN |     2 |    74 |     2   (0)| 00:00:01 |
---------------------------------