top of page
  • Writer's picturekyle Hailey
    • Sep 3, 2009
    • 1 min read

Statistics on function in predicates for CBO

ASSOCIATE STATISTICS WITH FUNCTIONS my_function DEFAULT SELECTIVITY 0.1; ASSOCIATE STATISTICS WITH FUNCTIONS my_function DEFAULT COST (10000, 1000, 0) /* cpu,io,net */; http://www.oracle-developer.net/display.php?id=426#

3 views0 comments

Recent Posts

See All

Alberto Dell’Era’s XPLAN

Check out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query: http://www.adellera.it/blog/2009/06/07/optimizing-sql-statements-with-xpla

SQL Videos

More videos from Stéphane Faroult I have yet to go through these videos but based on the previous two I posted from Stephane, these should be well worth looking at

bottom of page