Database Tuning (MOSC)

MOSC Banner

explain plan is different when check manually and live

edited Jun 3, 2012 12:56AM in Database Tuning (MOSC) 2 commentsAnswered
I have a table with 130 million rows with 30 hash  partiotions and five indexes as below. Some application is using below query.

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

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