Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Questions on hard coded vs bind variable performance
9i has both a cardinality() and a selectivity() hint, which can be used for single tables or a list of tables. Unfortunately the selectivity() hint seems to have broken in 10g.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated April 5th 2005 Received on Wed Apr 06 2005 - 12:43:40 CDT