Re: Function Based Indexes with in clause?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 9 Aug 2002 00:40:22 -0500
Message-ID: <uhei45sj8.fsf@hotpop.com>

On Fri, 09 Aug 2002, kennedy-family_at_attbi.com wrote:

> An in is just a bunch of ors. The CBO (cost based optimizer) might be
> thinking that it is cheaper to do a full table scan than an index look
> up on the number of things in the in clause.

I tried it as a list of OR's and no dice as well. The CBO definitely is making the incorrect decision on this one. I'm just not sure if there is some data the CBO needs that I'm not giving it. I analyzed the table, its indexes and columns. I put in hints and no dice.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.

Received on Fri Aug 09 2002 - 00:40:22 CDT