> -----Original Message-----
> From: PD Miller [mailto:[EMAIL PROTECTED]]
> Sent: Monday, April 30, 2001 6:31 PM
> To: Sterin, Ilya; Mike Schienle; [EMAIL PROTECTED]
> Subject: RE: Easiest way to tell if a table already exists?
>
>
> At 21:56 -0400 25/4/01, Sterin, Ilya wrote:
> >Why would (select * from foo) take up lost of resources?
> Won't it just
> >place the cursor at the first row and only return when rows
> are fetched?
>
> Speaking for Oracle, as soon as the statement is executed (and before
> any fetch) Oracle will execute the statement - and that means
> performing the full table scan(s) or index scan(s) necessary to
> fulfill the statement.
You missed the point. This all happens at the prepare with little cost. That
is what prepare is for.
Neil
__________________________________________________________________________
Please Note :
Only the intended recipient is authorised to access or use this e-mail. If
you are not the intended recipient,
please delete this e-mail and notify the sender immediately. The contents
of this e-mail are the writer's
opinion and are not necessarily endorsed by the Gunz Companies unless
expressly stated.
We use virus scanning software but exclude all liability for viruses or
similar in any attachment.
