Re: Tuning for IN subquery

>The following query returns the results quickly:
> SELECT * FROM VIEW1 WHERE KEY1 IN ('X1', 'X2', 'X3')
> while this query is very slow:
> SELECT * FROM VIEW1 WHERE KEY1 IN (SELECT KEY1 FROM TABLE1)
>
> VIEW1 joins many tables by KEY1. These tables are indexed by KEY1.
> TABLE1 has three rows with the same values for KEY1 as in the first
>query. It is not indexed.
>
> Is there a hint I can use to make the second query as fast as the
>first?
>
> Thanks,
> Dave Ball
> Lockheed Martin
>
>
>

Hi Dave,
  Have you tried the PUSH_SUBQ hint ?
HTH,
  Rob Received on Tue May 30 2000 - 00:00:00 CEST