Re: Datawarehousing query performance

From: Dave <slimdave_at_yahoo.com>
Date: 5 Apr 2002 10:32:15 -0800
Message-ID: <c502cdfc.0204051032.70e5a41_at_posting.google.com>

Apart from the usual "analyze everything" advice, do you have "star_transformation_enabled" set to TRUE for your instance? You might also set optimizer_index_cost_adj to 20 Received on Fri Apr 05 2002 - 20:32:15 CEST

This message: [ Message body ]
Next message: Johan Snyman: "Re: Newbie, Oralce stored procedures w/ exceptions"
Previous message: Tobie Berthon: "Re: multiple listeners"
In reply to: James A. Williams: "Datawarehousing query performance"
Next in thread: Johan Snyman: "Re: Newbie, Oralce stored procedures w/ exceptions"

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

Original text of this message