Home » SQL & PL/SQL » SQL & PL/SQL » NO_CPU_COSTING hint (Oracle 12c)
NO_CPU_COSTING hint [message #666345] Mon, 30 October 2017 10:09 Go to next message
srinivas.k2005
Messages: 364
Registered: August 2006
Senior Member
Hello,

Good day!!

In one of the queries where we are joining too many tables/view was having the execution plan cost around 3091219.
When I used the hint, /*+ NO_CPU_COSTING */ cost has come doing nearly 50% to 1412267.

Please let us know, if we can use the same or will it have any impact in future. The execution time is also better.

Thanks,
SRK


Re: NO_CPU_COSTING hint [message #666348 is a reply to message #666345] Mon, 30 October 2017 11:31 Go to previous messageGo to next message
John Watson
Messages: 7178
Registered: January 2010
Location: Global Village
Senior Member
Most likely your system stats are wrong or missing. You should gather them rather than using a hint to cover this up.
Re: NO_CPU_COSTING hint [message #666350 is a reply to message #666348] Tue, 31 October 2017 02:09 Go to previous messageGo to next message
srinivas.k2005
Messages: 364
Registered: August 2006
Senior Member
Thank you!!

Regards,
SRK
Re: NO_CPU_COSTING hint [message #666353 is a reply to message #666350] Tue, 31 October 2017 03:09 Go to previous message
John Watson
Messages: 7178
Registered: January 2010
Location: Global Village
Senior Member
If you post the results of SELECT * FROM SYS.AUX_STATS$ the cause of the problem may become clear.
Previous Topic: Multiple Rows to a Single Row
Next Topic: to_char date conversion not working
Goto Forum:
  


Current Time: Mon Dec 11 17:07:22 CST 2017

Total time taken to generate the page: 0.02479 seconds