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#

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-xplan/

--------------------------------------
02.|ColName     |1|2|3|4|5|P|U1|U2|R1|
03.--------------------U-U------------
04.|X           |1|1|2|1| |1|  |2 |  |
05.|PADDING     | | |1|2|1|2|R1|1 |  |
06.|RR          | | | | | | |  |  |1 |
07.|SYS_NC00004$|2| | | | | |  |  |  |
08.|SYS_NC00005$| |2| | | | |  |  |  |

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