Re: disabling use of VW_SNO_1

From: Sybrand Bakker <sybrandb_at_hccnet.nl>
Date: Thu, 26 Aug 2004 11:00:47 +0200
Message-ID: <ek9ri0tvdl8n59nm2ae0bm0555ove1lmuk@4ax.com>

On 25 Aug 2004 22:51:55 -0700, maks70_at_comcast.net (MAK) wrote:

>Please review the following SQL and Explain plan. How can I disable
>use of VW_NSO_1?

By switching to CBO and applying the NO_UNNEST hint. However, as the app apparently has been written for RBO, you may be in for other, unpleasant, surprises.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Aug 26 2004 - 04:00:47 CDT

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Oracle 8i and Oracle 9i Lite Sync"
Previous message: Rent Houses: "Re: Help: - dbstart on Oracle9i/redhat8"
In reply to: MAK: "disabling use of VW_SNO_1"
Next in thread: Romeo Olympia: "Re: disabling use of VW_SNO_1"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US