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>


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.com
Received on Sat Nov 15 2008 - 17:36:06 CST

Original text of this message