HI All
Iam trying to improve the performance if existing ,In the job there are few direct OCI lookups like this .
SELECT
PLT_FROM,
PLT_TO,
PLC_ID,
PLC_DESC
FROM STA_PROD_HIER_3
WHERE PLT_FROM<=:1 AND PLT_TO>=:2
If i remove and do Hash file lookup iam not getting the results as desired.
Could anyone help me " PLT_FROM<=:1 AND PLT_TO>=:2" would mean as i know PLT_FROM=:1 means you are making PLT_FROM as key for direct lookup but iam not sure what PLT_FROM<=:1 mean,your comments would be valuable for me .
OCI Direct lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Mon Feb 27, 2006 10:34 pm
- Location: Chennai
- Contact:
OCI Direct lookup
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
Cognizant technologies,Perungudi
Chennai
Code: Select all
WHERE PLT_FROM<=:1 AND PLT_TO>=:2
If you want to stick with the OCI lookup, ensure that query is as well tuned as possible. Or, search the forums for range lookup for other solutions.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers