Re: HOW 'VIEW' WORKS
From: Pauli Salmu <pauli.salmu_at_pp.kolumbus.fi>
Date: 1996/09/22
Message-ID: <3245142C.2EA1_at_pp.kolumbus.fi>#1/1
Date: 1996/09/22
Message-ID: <3245142C.2EA1_at_pp.kolumbus.fi>#1/1
Alex Yau wrote:
> I have a question about exactly how VIEW works in ORACLE.
> I would like to know how the SQL statement will be processed
> internally? Will the VIEW be created first(i.e. full table scan,
> sort/merge ...etc)
Easy: run EXPLAIN on your statement. Received on Sun Sep 22 1996 - 00:00:00 CEST