Hi,
I am having a query.
SELECT
*
FROM
"NRIV"
WHERE
"CLIENT" = :A0 AND "OBJECT" = :A1 AND "SUBOBJECT" = :A2 AND "NRRANGENR" = :A3
AND "TOYEAR" = :A4
FOR UPDATE
This is taking lot of time, to the tune of 800 secs sometimes.
It is waiting at enqueue.
NRIV Table s having 7066 Rows Only. Also has only One Index.
Can anyone help me in this ??
Regards
Vijay