Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    45

    Unanswered: Static SQL and Statistics connection...

    I just found out that at DB2, whenever statistics updated, when using static SQL, there's a function called REBIND which makes static SQL statement able to use the most recent statistics.

    Does anyone know whether Oracle has the similar way in dealing with static SQL and statistics ??? Does it necessary to recompile the static SQL statement ?? Or is Oracle already "rebind" the static SQL with the most recent statistics ??? If possible, please add reference as well, thank you...

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking Static SQL?

    There is no "static" SQL in Oracle, when statistics are computed, Oracle will change the execution plan accordingly.
    You may have two situations where the SQL may be considered somewhat 'static':

    1) You have "HINTS" on a query which control the execution plan.
    2) You have (and are using) Stored Outlines.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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