Re: index skip scan
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Tue, 6 Jan 2009 22:40:05 +0000 (UTC)
Message-ID: <gk0mk5$nn6$1_at_ss408.t-com.hr>
On Tue, 06 Jan 2009 08:29:17 -0800, Charles Hooper wrote:
Date: Tue, 6 Jan 2009 22:40:05 +0000 (UTC)
Message-ID: <gk0mk5$nn6$1_at_ss408.t-com.hr>
On Tue, 06 Jan 2009 08:29:17 -0800, Charles Hooper wrote:
> You are headed in the right direction. A stored outline may be used to
> force a specific execution plan for queries which cannot be modified.
Also, clustering factor of the inv_trans_qty_ind2 index can be set to lower value, which will probably result in CBO picking it over the skip-scan.
-- http://mgogala.freehostia.comReceived on Tue Jan 06 2009 - 16:40:05 CST