kyle HaileySep 3, 20091 min readStatistics on function in predicates for CBOASSOCIATE 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#
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#
Alberto Dell’Era’s XPLANCheck out Alberto Dell’Era’s SQL query analyzer – lots of good info like this compact table of indexes availble on the query:...
SQL VideosMore videos from Stéphane Faroult I have yet to go through these videos but based on the previous two I posted from Stephane, these...
Comments