PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Plan hash value: 1714491116

--------------------------------------------------------------------------------------
| Id  | Operation         | Name             | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |                  | 73812 |  4685K|  5768   (2)| 00:01:10 |
|*  1 |  TABLE ACCESS FULL| GBS_AUTORISATION | 73812 |  4685K|  5768   (2)| 00:01:10 |
--------------------------------------------------------------------------------------

Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------

   1 - SEL$1 / GBS_AUTORISATION@SEL$1

Outline Data
-------------

  /*+
      BEGIN_OUTLINE_DATA
      FULL(@"SEL$1" "GBS_AUTORISATION"@"SEL$1")
      OUTLINE_LEAF(@"SEL$1")
      DB_VERSION('11.2.0.1')
      OPTIMIZER_FEATURES_ENABLE('11.2.0.1')
      IGNORE_OPTIM_EMBEDDED_HINTS
      END_OUTLINE_DATA
  */

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

   1 - filter("CODEBLOCAGE"=' ' OR "CODEBLOCAGE"='B' OR "CODEBLOCAGE"='X')

Column Projection Information (identified by operation id):
-----------------------------------------------------------

   1 - "AU_REFACQNUM"[VARCHAR2,12], "AU_NUMAUTO"[VARCHAR2,6],
       "AU_NUMCARTE"[VARCHAR2,19], "AU_DATAUTO"[VARCHAR2,8],
       "AU_HEUREAUTO"[VARCHAR2,6], "AU_CODCATEG"[VARCHAR2,4],
       "MONTANTMONNAIELOCALE"[VARCHAR2,12]

39 ligne(s) selectionnee(s).