SQL Performance (MOSC)

MOSC Banner

How can I fast My Query

edited May 23, 2013 5:34AM in SQL Performance (MOSC) 26 commentsAnswered
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center