ORACLE PAGING PERFORMANCE

From: <sandro.salari_at_gmail.com>
Date: 10 Feb 2006 07:52:29 -0800
Message-ID: <1139586749.095305.156350@g14g2000cwa.googlegroups.com>

I have a quest.
This query

SELECT /*+USE_NL(nodi) */ nodi.* FROM V_MT_NODI nodi,W_MT_NRL linee WHERE 1=1 and linee.IL_LINEA=0 AND linee.IK_LINEA=16705 AND linee.IM_LINEA=1000 AND nodi.IK_NODO = linee.IK_NODO ORDER BY nodi.COD_ORG,nodi.SER_NODO,nodi.NUM_NODO

needs 3s to extract the data.

The next one

( SELECT * FROM (SELECT ROWNUM AS N, a.* FROM (( SELECT /*+USE_NL(nodi) */ nodi.* FROM V_MT_NODI nodi,W_MT_NRL linee WHERE 1=1 and linee.IL_LINEA=0 AND linee.IK_LINEA=16705 AND linee.IM_LINEA=1000 AND nodi.IK_NODO = linee.IK_NODO ) ORDER BY nodi.COD_ORG,nodi.SER_NODO,nodi.NUM_NODO)a where rownum<=20)WHERE N>0 )

needs 86s.

Can anyone explain me why?
tanx
Sandro. Received on Fri Feb 10 2006 - 09:52:29 CST