Database Tuning (MOSC)

MOSC Banner

cost of query --analyzing problem

edited Mar 8, 2010 9:56PM in Database Tuning (MOSC) 8 commentsAnswered
 Hi

for decreasing the cost of query we analyze table and indexes related to the query in our environment .but recently this frequency for request for analyizing objects has been increased.

is there a better way rather than analyzing to decrease the cost of query ?

when we do not analyze this objects although database's total responce time is low but the cost of query is too high and this is sensed at application level very obvious.

Please kindly advice.

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