top of page

Statistics on function in predicates for CBO

Writer: kyle Hailey
kyle Hailey
Sep 3, 2009
1 min read

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#

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:...

 
 
 
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...

 
 
 

3 Comments


Jai Sharma
Oct 21

Does anyone have advice on how to choose a baby name that has a beautiful meaning, is easy to pronounce, and will still feel suitable when the child grows up?


Like

Jai Sharma
Oct 21

I’ve been exploring a prompt generator lately, and it makes coming up with creative ideas much easier when I’m short on inspiration.


Like

philipsalt
Oct 08

A se lekar Gya tak hindi varnmala ko samajhna ab easy lag raha hai. Beginners ke liye achha article hai.

Like

Kyle Hailey

  • Facebook
  • Twitter
  • LinkedIn
  • Instagram

San Franisco, Ca 94131

415-341-3430  (please text initially before calling)

bottom of page