SELECT * 
FROM TBLEGAMI 
WHERE CDCOMUNICAZIONE = : 1  AND CDTPLEGAME = : 2  AND CDTPENTITA = : 3  AND CDLIV1 = : 4  
AND CDLIV2 = : 5  AND CDPROP = : 6  AND FLSTATO = : 7 
					

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse       547        0 . 01         0 . 10            0            0            0             0 
Execute     547        3 . 74         9 . 82            0            0            0             0 
Fetch       466        0 . 15         0 . 74            0          985            0           466 
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total      1560        3 . 90        10 . 68            0          985            0           466 

Misses in library cache during parse:  0 
Optimizer mode: ALL_ROWS
Parsing user id:  5102   (User_id)

Rows     Row Source Operation
-------  ---------------------------------------------------
       1   SEQUENCE  (cr= 2  pr= 0  pw= 0  time= 16442  us)


Rows     Execution Plan
-------  ---------------------------------------------------
       0   SELECT STATEMENT   MODE: ALL_ROWS
       1    TABLE ACCESS   MODE: ANALYZED (BY INDEX ROWID) OF 'TBLEGAMI' 
              (TABLE)
       0     INDEX   MODE: ANALYZED (RANGE SCAN) OF 'XS4_TBLEGAMI' (INDEX)


Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  latch: shared pool                            1364          0 . 04            8 . 39 
  SQL*Net message to client                     1013          0 . 00            0 . 00 
  latch: library cache                            18          0 . 01            0 . 08 
********************************************************************************