OCI Direct lookup

mdtauseefhussain · Post by **mdtauseefhussain** » Tue Jun 17, 2008 4:41 am

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 .

chulett · Post by **chulett** » Tue Jun 17, 2008 6:17 am

Code: Select all

WHERE PLT_FROM<=:1 AND PLT_TO>=:2

Means you have two Key fields. The lookup is done where PLT_FROM is less than or equal to the first Key value and PLT_TO is greater than or equal to the second Key value.

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.