[firebase-br] Performace Consulta SQL
moura
silasmoura em polmil.sp.gov.br
Sex Maio 26 09:41:14 -03 2006
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
Mais detalhes sobre a lista de discussão lista