Re: Filtered Indexes

[Alan Campin <alan0307d@xxxxxxxxx>]

You must have V7R1 for SQL to use the drived indexes. They added the support
in V6R1 but SQL doesn't use it until V7R1.

On Mon, Mar 28, 2011 at 1:38 PM, Ryan Hunt <ryan.hunt@xxxxxxxxxxxxx> wrote:

> Can't get DB/400 to use a filtered index (binary radix index with a where
> clause).  I even created one as a test that was ridiculous and met up a
> exactly with the where clause of a query and should have been able to use
> index only access.  Yet, I can't get our system to use it.
>
> We're on V6R1.  Is there some requirement I might be missing?  For example,
> I know that index/table partitioning only works if DB2 Multisystem is
> installed.  Is there some similar requirement for using indexes creating
> with a WHERE clause??
>
> Thanks
>
> Ryan
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.