2 queries on 2 Sun boxes 1 takes too long

A database is installed on 2 Suns A spac 2 and a Sparc 1000. Same data in each database . Same structure. A 4gl query takes 1 minute on Sparc 2, 15 minutes on on Sparc 1000. Any ideas? below is sqlexplain.out Sparc 2 QUERY: ------ select control_id , control_cage from m_config_d where sup_doc_id = ? andsup_d Estimated Cost: 6 Estimated # of Rows Returned: 1 Temporary Files Required For: Order By 1) icm.m_config_d: INDEX PATH 1) icm.m_config_d: INDEX PATH (1) Index Keys: sup_doc_id sup_cage Lower Index Filter: (icm.m_config_d.sup_doc_id = 'SM-D-771480-1 ' AND Sparc 10000 UUERY: ------ select control_id , control_cage from m_config_d where sup_doc_id = ? andsup_c age = ? order by control_id Estimated Cost: 2 Estimated # of Rows Returned: 1 1) icm.m_config_d: INDEX PATH Filters: (icm.m_config_d.sup_doc_id = 'SM-D-771480-1 ' AND icm.m_config_d.s up_cage = '80063' ) (1) Index Keys: control_id control_cage sup_doc_id sup_cage (Key-Only) Sparc 1000 does not use index on sup_doc_id,sup_cage that Sparc 2 does. Many thanks. ciao p ****************************************************************************** Peter Wages EDS Arlington, Virginia pmwages@cais.com Work: (703) 741-7436 Home: (202) 244-3511 Anywhere is walking distance, if you have the time ******************************************************************************