Re: Question about Queries
From: William Robertson <williamr2019_at_googlemail.com>
Date: Thu, 25 Dec 2008 05:30:42 -0800 (PST)
Message-ID: <69a21439-3ab7-4eff-a066-593de1406bf8@z6g2000pre.googlegroups.com>
Date: Thu, 25 Dec 2008 05:30:42 -0800 (PST)
Message-ID: <69a21439-3ab7-4eff-a066-593de1406bf8@z6g2000pre.googlegroups.com>
On Dec 24, 9:30 pm, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> >Second, is using EXECUTE IMMEDIATE for doing a SELECT faster than a
> >normal coded SELECT?
I must admit I could never see the sense of the "IMMEDIATE" keyword here. Perhaps the standard allows for some "DEFERRED" option for background submission, that no vendor currently supports? Otherwise you'd think EXECUTE STATEMENT would have made rather more sense. Then again anything is possible from the geniuses who came up with LEFT and RIGHT alternatives for join syntax. Received on Thu Dec 25 2008 - 07:30:42 CST