Re: index skip scan
Date: Tue, 6 Jan 2009 22:40:05 +0000 (UTC)
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.Received on Tue Jan 06 2009 - 16:40:05 CST