sql query hint - first filter , then join
hello
i have a following query (based on OWB data model views)
select /* + LEADING(all_iv_xform_map_components all_iv_xform_map_parameters) USE_NL(all_iv_xform_map_components all_iv_xform_map_parameters) */
comp.map_name,
comp.operator_type ,
param.map_component_name ,
param.parameter_name,
md.map_component_id,
md.map_component_name,
mp.MAP_COMPONENT_ID ,
mp.MAP_COMPONENT_NAME
from all_iv_xform_map_components comp,
all_iv_xform_map_parameters param,
ALL_IV_XFORM_MAP_PROPERTIES mp,
ALL_IV_XFORM_MAP_DETAILS md
where comp.map_name = nvl('&load_map_name','LOAD_MY_TABLE')
and param.map_component_id = comp.map_component_id
and param.map_component_id=md.map_component_id
and md.map_component_id=mp.map_component_id
what i want to achieve is to force the query to first filter out the table all_iv_xform_map_components and do the join with the remainign tables on the filtered rows only;
i tried using the above hint but its not working; oracle still grabs to the full table: ALL_IV_XFORM_MAP_PROPERTIES
id appreciate any tips
thanks
rgds