Re: Stored procedures and "select" requires "into"...why?
From: Kevin Neel <k-neel_at_nwu.edu>
Date: 27 Jan 1994 22:48:07 GMT
Message-ID: <2i9gb7$1ul_at_anaxagoras.ils.nwu.edu>
Date: 27 Jan 1994 22:48:07 GMT
Message-ID: <2i9gb7$1ul_at_anaxagoras.ils.nwu.edu>
Two things:
- Oracle V7 automatically caches the parse of your statement globally across all processes. Of course, it can trash that cache, but if you use the statement often enough to matter, it probably isn't a big deal.
- You'd probably be better off TRUNCATEing and INSERTing your temp table, rather than recreating it all the time, if you really feel the need to use one.
Note: I'm not sure that using a stored procedure will help; Oracle may wish to leave the parse out of the compilation so that it can optimize based on data distribution. Received on Thu Jan 27 1994 - 23:48:07 CET