Re: index skip scan

From: Mladen Gogala <>
Date: Tue, 6 Jan 2009 22:40:05 +0000 (UTC)
Message-ID: <gk0mk5$nn6$>

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

Original text of this message