Database Tuning (MOSC)

MOSC Banner

Is it good to use PARALLEL hint for OLTP system?

edited Oct 28, 2009 4:38AM in Database Tuning (MOSC) 3 commentsAnswered
 Hi,

       We had a query which is giving poor response time when we query it for a particular status records from a status column. The index on the other column of the table which is having the status column is being used, which is fine when we query for the records not filtering with status. But if we want to go for filtering with status it is not using the index on the status column. Only option we have is to force the index on the status column through the hint, which is not feasible as this is a report and different

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