Re: Filtered Indexes

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Good catch Alan...

Basically, the support at 6.1 was to allow for SQL DDL based
replacements of DDS select/omit logicals.

Charles

On Mon, Mar 28, 2011 at 4:10 PM, Alan Campin <alan0307d@xxxxxxxxx> wrote:
> 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.
> --
> 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.