Re: How to speed up this
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Sat, 15 Nov 2008 23:36:06 +0000 (UTC)
Message-ID: <gfnmd6$u7o$1@solani.org>
Date: Sat, 15 Nov 2008 23:36:06 +0000 (UTC)
Message-ID: <gfnmd6$u7o$1@solani.org>
On Sat, 15 Nov 2008 13:46:22 +0100, astalavista wrote:
> Hi,
>
> Have you any hint to speed up the query below ?
Don't execute it. It's a query to SYS objects in which you are looking for the number of differences between the objects owned by different owners. Create a table containing source and destination, index it properly and then calculate the differences.
-- http://mgogala.freehostia.comReceived on Sat Nov 15 2008 - 17:36:06 CST