Re: SQL Problem w/MINUS

select

       c.cust_nbr
  from customer c,

       order o

  where c.cust_nbr = o.cust_nbr
    and c.age >= 30
    and o.amount < 10;

and force hash_join.

maybe create index on customer ( cust_nbr, age ) and order ( cust_nbr, amount ) and try to force merge join using these indexes.

        Starous Received on Tue Sep 26 2000 - 03:21:30 CDT