Re: SQL Performance Problem

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Feb 2006 11:07:45 -0800
Message-ID: <1138907265.295816.229580@g47g2000cwa.googlegroups.com>

First are these the actual true form of the queries or when the queries are executed are some values added in?

Try regenerating the statistics with all columns size 1 to eliminate the histograms and see what the explain plan comes up with.

Before you do that you might want to look at the column level statistics for object_id and attr_id to see if either contains shewed data. You might try comparing the statistics to reality (distinct count, number null, etc...)

Exactly what version of Oracle and what platform is this?

HTH -- Mark D Powell -- Received on Thu Feb 02 2006 - 13:07:45 CST