RE: QAQQINI

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

1) you don't copy (i.e. CPYF), you duplicate (CRTDUPOBJ). If you don't have
authority, have an admin do it for you.
2) CHGQRYA, but QAQQINI has to be duplicated there first (there are triggers
that come with it)
3) pre-V6R1 it would default IGNORE_DERIVED_INDEX to *NO. V6R1 and later
defaults to *YES.

If you have truly removed all select/omit LFs over the two tables you're
querying, then you don't need to set that setting anyway.  Your query should
be using SQE now.

Not having a QAQQINI in QUSRSYS is not an error, just an informational
message.

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com

-----Original Message-----
Subject: QAQQINI

All,

Having some performance problems : 

Visual explain says CQE used because of derived key or select/omit.
Got rid of all select/omit LFs.
Created all advised indexes.

In STRSQL I get the message in the log <impossible to extract the request
options file>

QAQQINI only exists in QSYS. The message says to create the file in QUSRSYS
or indicate where to find it. 

1. I can't copy from QSYS because of authority.
2. How do I indicate another library?
3. Does not having the file result in IGNORE_DERIVED_INDEX *yes or *no ?

Here's my request :

SELECT * FROM
clients join clientaddress on clients.client_id = clientaddress.client_id

Join
addresses on clientaddress.address_id=addresses.address_id

WHERE avil like 'PARIS%'

                   
Could someone explain exactly what is meant by <derived> index?

Thanks.