Viskagite svoe mnenie

SELECT codifica_sist_arrivo
  FROM trascodifica
 WHERE (    (    (    (    RTRIM (compagnia) = RTRIM (:b2)
                       AND RTRIM (sistema_partenza) = RTRIM (:b3)
                      )
                  AND RTRIM (sistema_arrivo) = RTRIM (:b4)
                 )
             AND RTRIM (dominio_sist_arrivo) = RTRIM (:b5)
            )
        AND RTRIM (codifica_sist_partenza) = RTRIM (:b6)
       )
Execution Plan
----------------------------------------------------------
Plan hash value: 3970702705

----------------------------------------------------------------------------------
| Id  | Operation         | Name         | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |              |     1 |    34 |    42   (3)| 00:00:01 |
|*  1 |  TABLE ACCESS FULL| TRASCODIFICA |     1 |    34 |    42   (3)| 00:00:01 |
----------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(RTRIM("COMPAGNIA")=:B2 AND RTRIM("SISTEMA_PARTENZA")=:B3
              AND RTRIM("SISTEMA_ARRIVO")=:B4 AND RTRIM("DOMINIO_SIST_ARRIVO")=:B5 AND
              RTRIM("CODIFICA_SIST_PARTENZA")=:B6)


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
        184  consistent gets
          0  physical reads
          0  redo size
        173  bytes sent via SQL*Net to client
        224  bytes received via SQL*Net from client
          1  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          0  rows processed

Execution Plan
----------------------------------------------------------
Plan hash value: 327769594

----------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name                 | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT            |                      |     1 |    35 |    40   (0)| 00:00:01 |
|*  1 |  TABLE ACCESS BY INDEX ROWID| TRASCODIFICA         |     1 |    35 |    40   (0)| 00:00:01 |
|*  2 |   INDEX RANGE SCAN          | XS_TEMP_TRASCODIFICA |    98 |       |     9   (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter(RTRIM("SISTEMA_PARTENZA")=:B3 AND RTRIM("SISTEMA_ARRIVO")=:B4 AND
              RTRIM("DOMINIO_SIST_ARRIVO")=:B5 AND RTRIM("CODIFICA_SIST_PARTENZA")=:B6)
   2 - access(RTRIM("COMPAGNIA")=:B2)


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
        181  bytes sent via SQL*Net to client
        224  bytes received via SQL*Net from client
          1  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          0  rows processed

SELECT codifica_sist_arrivo
  FROM trascodifica
 WHERE compagnia LIKE RTRIM(:b2)||'%'
           ...

SELECT codifica_sist_arrivo
  FROM trascodifica
 WHERE compagnia LIKE RTRIM(:b2)||'%'
           ...

SQL> select ename from emp where rtrim(ename)=rtrim('A');

no rows selected

SQL> select ename from emp where ename like rtrim('A')||'%';

ENAME
----------
ALLEN
ADAMS