Strickland, Mark wrote: >If there are only a few columns in the select list, you might consider >indexes that contain those columns along with the columns referenced in >the where clauses so that Oracle just does index joins. > > So, basically, what you are saying is that the best way of speeding up a big hash join is by eliminating it? -- Mladen Gogala Oracle DBA Ext. 121 -- //www.freelists.org/webpage/oracle-l