explain plan is different when check manually and live
This query is being executed thousand times all the the time top query of the database.When is check the explain plan nothing iswrong with it but when I check the live explain plan explain is different full table scan is going on.
Can I create bitmap index on the LOC column. It has 1000 distinct values?
Please help to achieve the better performance for the below query.
SELECT "ITEM","LOC","STOCK_ON_HAND"FROM "ITEM_LOC_SOH" "B"WHERE