Re: How to find the Overall cost of a query?

From: Jimbo1 <nightfanguk_at_yahoo.co.uk>
Date: 19 Dec 2005 09:32:03 -0800
Message-ID: <1135013523.188342.73420@g44g2000cwa.googlegroups.com>

You might find this following link of interest:

http://asktom.oracle.com/pls/ask/f?p=4950:8:11819150469539176179::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:313416745628

The gist of it is though, cost should not be used as a tuning stat. It is almost like a random number. From my own experience, whenever you apply a hint to a query, the cost increases. However, I've applied a hint to a query, seen four times the cost, and the query has run over 30 times faster (Execution time dropped to 2 hours from 65 hours). Received on Mon Dec 19 2005 - 11:32:03 CST