the hint I use most often .... QB_NAME I use it as much as possible since it helps find a particular query for troubleshooting. (10 and up). cardinality would be the next. It give the optimizer better information. -- //www.freelists.org/webpage/oracle-l