Re: ACCELERATING STORE PROCEDURE
From: <sybrandb_at_hccnet.nl>
Date: Thu, 19 Feb 2009 22:20:27 +0100
Message-ID: <i7jrp4t416mqqv1c0bnpar57f3ld2k22fm_at_4ax.com>
On Thu, 19 Feb 2009 11:29:14 -0800 (PST), Jorge Reyes <jorg_reyes_at_hotmail.com> wrote:
Date: Thu, 19 Feb 2009 22:20:27 +0100
Message-ID: <i7jrp4t416mqqv1c0bnpar57f3ld2k22fm_at_4ax.com>
On Thu, 19 Feb 2009 11:29:14 -0800 (PST), Jorge Reyes <jorg_reyes_at_hotmail.com> wrote:
>
>Hoping you are ok, i need your help to solve this query in order to
>make faster an stored procedure, it goes likes this:
Just remove all the redundant SELECT COUNT(*) and it will be 2 times faster.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Feb 19 2009 - 15:20:27 CST