[firebase-br] Performace Consulta SQL

[moura]

Pessoal
Como fazer esta leitura e  verificar qual é a melhor.
Preciso de ajuda.
 1º) -- SELECT COUNT(*) FROM COCR_PESSOA B INNER JOIN COCR_FINAL
 A ON (A.CODIGO = B.CODOCR AND A.CODNATFINAL = 'XX1')
 INNER JOIN QUALIFICACAO C ON (B.CODPESSOA = C.CODIGO AND C.COD_TIPO = 3 OR 
C.COD_TIPO=4)
Plan PLAN JOIN (JOIN (B NATURAL,A INDEX (PK_COCR_FINAL)),C NATURAL)
Adapted Plan PLAN JOIN (JOIN (B NATURAL,A INDEX (PK_COCR_FINAL)),C NATURAL)
------ Performance info ------
Prepare time = 15ms, Execute time = 0ms, Avg fetch time = 0,00 ms, Current 
memory = 859.656 ,Max memory = 924.416,
Memory buffers = 2.048, Reads from disk to cache = 0, Writes from cache to 
disk = 0, Fetches from cache = 2.398

2º) --SELECT COUNT(*) FROM COCR_PESSOA B INNER JOIN COCR_FINAL A ON 
(A.CODIGO = B.CODOCR )
INNER JOIN QUALIFICACAO C ON (B.CODPESSOA = C.CODIGO)  WHERE A.CODNATFINAL = 
'XX1'
 AND C.COD_TIPO = 3  OR C.COD_TIPO = 4
Plan PLAN JOIN (B NATURAL,C INDEX (PK_QUALIFICACAO),A INDEX (PK_COCR_FINAL))
Adapted Plan PLAN JOIN (B NATURAL,C INDEX (PK_QUALIFICACAO),A INDEX 
(PK_COCR_FINAL))
------ Performance info ------
Prepare time = 0ms, Execute time = 0ms, Avg fetch time = 0,00 ms,  Current 
memory = 860.084, Max memory = 924.416,
Memory buffers = 2.048,  Reads from disk to cache = 0,  Writes from cache to 
disk = 0, Fetches from cache = 940