RE: SQL Optimizer Issue

I'm a little confused/concerned by this. I'm trying to understand a
couple of things:

>If a derived index exists, have CQE process the query.

Does this mean that if the derived index exists SQE won't get a crack at
it at all? Or that SQE will defer to CQE _IF_ CQE could do a better job?

>The index types that are ignored include:
>SQL index ... Shared weight.

So if the value is *NO (default), and I create a SQL index with shared
weighting of values (case insensitive) SQE will IGNORE that index? That
is, if I want to use the index I created with shared weighting I need to
set the value to *YES and force the query through the CQE? 

I can't believe that IBM would not allow us to use the "new" SQE for
case insensitive searches -- but that's how I read it. Heck, I want all
my searches to be case insensitive.

-Walden


------------
Walden H Leverich III
Tech Software
(516) 627-3800 x11
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)