It has already done so. The selectivity hint is gone in 10g. I would have preferred it over the cardinality hint - at least at times. Post, Ethan wrote: > > What if Oracle decides to drop other hints for indexes, join types > etc...? > -- Regards Wolfgang Breitling Centrex Consulting Corporation www.centrexcc.com -- //www.freelists.org/webpage/oracle-l