Why a query take a long time on a relative small table?

From: Paul Cao <paulc>
Date: 1996/07/31
Message-ID: <4toiu7$f7v_at_pgs-gw.hstn.expl.pgs.com>#1/1

Hi,

        In our software, we have a query that seems to take forever to response. Basically, the query is

         SELECT A, B, C, D, ...
         FROM VIEW (a view)
         WHERE A IN ('HELLO'),
               B IN ('THE'),
               C IN ('WORLD'),
           AND D IN ('OK');

This query takes about 7 minutes or more to response (TKPROF). If I remove one condition in the WHERE then it responses immmediately. I tried to look into how the view is define in DBA_VIEWS, but only able to see partially how the view is defined.

First, how do I export a complete table of DBA_VIEWS (I was able to export but the lines is toolong so it comes out missing important stuff) or find out how a view is defined?
Second, any insight into above problem is greatly appreciated.

                                                        Paul Received on Wed Jul 31 1996 - 00:00:00 CEST