Re: Query with LONG RAW

From: Sybrand Bakker <>
Date: Tue, 02 Mar 2010 23:16:19 +0100
Message-ID: <>

On Tue, 2 Mar 2010 21:46:51 +0100, "bob123" <> wrote:

>How can I speed up the query below (third party software)
>it takes 30 min to execute.

Apparently the table has heavy row chaining, which means 1 row is in more than 1 block. This is always resulting in severe performance hits.
There is nothing wrong with the query, the design of that table is wrong, as is still running a desupported release of Oracle.

Sybrand Bakker
Senior Oracle DBA
Received on Tue Mar 02 2010 - 16:16:19 CST

Original text of this message