Long Query chokes in 7.3 but not in 7.1

We've run into a problem where we have an SQL query that's pretty long, and joins about 7 or 8 tables. Most of the where clause are things like a.value = 'CONSTANT' and b.value='CONSTANT'.

We set up the exact same tables and data under Oracle 7.1 and Oracle 7.3:

On Oracle 7.1, the query works fine.

On Oracle 7.3, Oracle hangs, and we have to shutdown abort the database to get control back. We changed the query to do some joins like a.value = b.value, etc.

Any ideas? We haven't encountered this kind of problem before.

--
Greg Gershowitz mailto:gregg_at_charlotte.computex.com

International CompuTex, Inc.            http://www.computex.com

(704)547-7383 x230                      FAX: (704)548-1948