Problems with COUNT(*) and CBO
From: artxe <ji_mminm_at_hotmail.com>
Date: 24 Jul 2002 02:38:11 -0700
Message-ID: <9309cb1f.0207240138.4ee36ae1_at_posting.google.com>
T.NIF,
T.AP
FROM
WHERE
(RP.D = D.DD) AND
((RP.DD = RC.DD AND RP.MNC = RC.MNC AND RP.IMPTCN = RC.IMPTCN) AND
(RC.NMR_D = T.NMR_ID) AND (RC.RDN = 1))
And I have this query for this view
SELECT *
FROM VW1
WHERE PRV = 1 AND MNC = 2 AND POL = 3 AND PAR = 4 AND MUNIAGR = 5 AND ZCON = 6 I use CBO. And The query is all right. But If I have SELECT COUNT I have a FULL ACCESS in table D.
Date: 24 Jul 2002 02:38:11 -0700
Message-ID: <9309cb1f.0207240138.4ee36ae1_at_posting.google.com>
Hi,
I have this view VW1:
SELECT
TO_CHAR (RP.DD, 'FM09') || TO_CHAR (RP.MNC, 'FM099') || RP.SECTOR ||
TO_CHAR(RP.POL, 'FM099') || TO_CHAR(RP.PAR, 'FM09999') || '0000' ||
RP.PRC_DC1 || RP.PRC_DC2 REF,
D.PRVINE PRV,
RP.DD, RP.MNC, RP.MUN_AGR MUNIAGR, RP.ZONA ZCON, RP.POL, RP.PAR,
T.NIF,
T.AP
FROM
SIT.RP, SIT.D, SIT.RC, SIT.T
WHERE
(RP.D = D.DD) AND
((RP.DD = RC.DD AND RP.MNC = RC.MNC AND RP.IMPTCN = RC.IMPTCN) AND
(RC.NMR_D = T.NMR_ID) AND (RC.RDN = 1))
And I have this query for this view
SELECT *
FROM VW1
WHERE PRV = 1 AND MNC = 2 AND POL = 3 AND PAR = 4 AND MUNIAGR = 5 AND ZCON = 6 I use CBO. And The query is all right. But If I have SELECT COUNT I have a FULL ACCESS in table D.
¿Why?
Thanks y excuse me again for my English
ji_mminm_at_hotmail.com Received on Wed Jul 24 2002 - 11:38:11 CEST