makiju
28th July 2008, 15:46
Hi,
I am not a programmer...I would like to ask what is the idea of executing row counting in session in general? It's causing FTS in oracle-level in many places in LN.
One example:
Starting of session whinh4525m000:
SELECT /*+FIRST_ROWS(2)*/
COUNT (*)
FROM erpln6a.twhinh225260 a0,
erpln6a.twhwmd400260 a1,
erpln6a.twhwmd200260 a2,
erpln6a.twhwmd400260 a3,
erpln6a.ttcibd001260 a4,
erpln6a.twhwmd200260 a5,
erpln6a.ttcmcs003260 a6
WHERE (a0.t$pckd = :1 OR a0.t$pckd = :2)
AND (a0.t$rlsd = :3 OR a0.t$rlsd = :4)
AND a6.t$cwar(+) = a5.t$cwar
AND a5.t$cwar(+) = a0.t$cwar
AND a4.t$item(+) = a3.t$item
AND a3.t$item(+) = a0.t$item
AND a2.t$cwar(+) = a0.t$cwar
AND a1.t$item(+) = a0.t$item
I am not a programmer...I would like to ask what is the idea of executing row counting in session in general? It's causing FTS in oracle-level in many places in LN.
One example:
Starting of session whinh4525m000:
SELECT /*+FIRST_ROWS(2)*/
COUNT (*)
FROM erpln6a.twhinh225260 a0,
erpln6a.twhwmd400260 a1,
erpln6a.twhwmd200260 a2,
erpln6a.twhwmd400260 a3,
erpln6a.ttcibd001260 a4,
erpln6a.twhwmd200260 a5,
erpln6a.ttcmcs003260 a6
WHERE (a0.t$pckd = :1 OR a0.t$pckd = :2)
AND (a0.t$rlsd = :3 OR a0.t$rlsd = :4)
AND a6.t$cwar(+) = a5.t$cwar
AND a5.t$cwar(+) = a0.t$cwar
AND a4.t$item(+) = a3.t$item
AND a3.t$item(+) = a0.t$item
AND a2.t$cwar(+) = a0.t$cwar
AND a1.t$item(+) = a0.t$item