cost of query --analyzing problem
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.