Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: Explanation of Syntax: /* No_CPU_Costing */

    Hi all,

    I'm fairly new to Oracle SQL with my background being in MySQL so there are a number of tools that I'm not familiar with but there are also a few that I just can't find any documentation about...
    The Oracle Hint of...
    ... is one of them. I have tried google but just get the same statement from the same person in a number of places.

    Can anyone explain what this actually does? Does it improve the speed of my query or is it just for analysis within the explain plan and have no real impact on the execution?

    I only ask because I used the SQL Optimizer and it suggested this as one of the alternatives thus reducing the plan cost from 260,000 to 8,500. It didn't appear to have a difference on the run time but then again it's only taking 40 seconds to begin with. I don't want to play around with it without knowing what it actually does.

    Thank you,


  2. #2
    Join Date
    Jun 2004
    Provided Answers: 1
    Is this the statement you keep getting?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    the hint /* No_CPU_Costing */ will make the SELECT slower, faster, or have no impact depending other factors considered by CBO

    Actual testing in your application is required to determine the impact for your environment.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts