Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why so many LIO's for select statement doesn't fetch any rows?
This is my query plan
Rows Row Source Operation
------- --------------------------------------------------- 0 TABLE ACCESS BY INDEX ROWID ATTRIBUTE_VAL_HEADERS 0 INDEX RANGE SCAN I_ATTRIBUTE_VAL_HEADERS_FK4 (objectid 33065)
SELECT UNQ_ATT_ID
FROM
ATTRIBUTE_VAL_HEADERS WHERE OBJECT_ID = :b1 AND DEFINITION_ID = :b2
AND
DATA_SOURCE = :b3
Received on Fri Apr 01 2005 - 00:07:04 CST
![]() |
![]() |