Success is about Imagination

Ignite Your Passion

kyle Hailey

Sep 3, 20091 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...

3 views0 comments

kyle Hailey

Sep 3, 20091 min read

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

19 views0 comments

kyle Hailey

Jun 10, 20091 min read

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

4 views0 comments