Re: Query with LONG RAW
Date: Tue, 02 Mar 2010 23:16:19 +0100
On Tue, 2 Mar 2010 21:46:51 +0100, "bob123" <bob123_at_gmail.com> wrote:
>How can I speed up the query below (third party software)
>it takes 30 min to execute.
>LONG RAW on PFMQ_MESSAGEDATASTORAGE
Apparently the table has heavy row chaining, which means 1 row is in
more than 1 block. This is always resulting in severe performance
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 DBAReceived on Tue Mar 02 2010 - 16:16:19 CST