How can I fast My Query
Hi
I have made a query to get my result
Query Is
select mfi.*
FROM mrp_forecast_interface mfi, mtl_system_items_b msi
WHERE mfi.forecast_date >= '11-Feb-13'
AND mfi.inventory_item_id = msi.inventory_item_id
AND msi.attribute2 = '2222222-1'
AND msi.organization_id=121
ORDER BY mfi.forecast_date ASC;
It is very slow
I have created index for inventory_item_id , attribute2,organization_id
But still it is slow.
when I remove organization_id condition it is running very fast.
Index on table are
attribute2,organization_id
and
inventory_item_id,organization_id
I have made a query to get my result
Query Is
select mfi.*
FROM mrp_forecast_interface mfi, mtl_system_items_b msi
WHERE mfi.forecast_date >= '11-Feb-13'
AND mfi.inventory_item_id = msi.inventory_item_id
AND msi.attribute2 = '2222222-1'
AND msi.organization_id=121
ORDER BY mfi.forecast_date ASC;
It is very slow
I have created index for inventory_item_id , attribute2,organization_id
But still it is slow.
when I remove organization_id condition it is running very fast.
Index on table are
attribute2,organization_id
and
inventory_item_id,organization_id
0