Re: How to speed up this

From: Mladen Gogala <>
Date: Sat, 15 Nov 2008 23:36:06 +0000 (UTC)
Message-ID: <gfnmd6$u7o$>

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.

Received on Sat Nov 15 2008 - 17:36:06 CST

Original text of this message