TKPROF output - do I understand it correctly?
Using a software I run a query to search for a person using its birth date (SSSN).
SELECT R0.sFirstName, R0.sLastName, R0.sEmail, R0.iCustomerMasterId,
R0.iRecipientId
FROM
NmsRecipient R0 WHERE ((R0.iFolderId = :1) AND ((Upper(R0.sSsn) LIKEC :2 ||
Upper(:3) || :4 ESCAPE '\')))
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.03 0.05 0 0 0 0
Fetch 1 27.49 46.12 12056 12056 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 27.53 46.17 12056 12056 0 1
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: FIRST_ROWS
Parsing user id: 60
Number of plan statistics captured: 1
Rows (1st) Rows (avg) Rows (max) Row Source Operation