× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



DB2 always knows related SQL objects of a table no matter what library they
live in, even if not in the *LIBL.

JS


El jue, 14 dic 2023 a las 16:55, Charles Wilt (<charles.wilt@xxxxxxxxx>)
escribió:

I often made use of this fact when digging into SQL performance issues in
production...

I couldn't create objects in the production libraries. But I could create
indexes in my own personal library over production tables in production
libraries.

This allowed me to see what effect they would have on particular queries
before going to our change management process to make them permanent.

Charles



On Thu, Dec 14, 2023 at 2:34 PM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

Yes indeed.

In fact, the DB can always use an access path, regardless of the library
or authorities on on object.

Charles

On Thu, Dec 14, 2023 at 2:30 PM Musselman Paul via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

A question arose with WebQuery queries written using views in a library
NOT in the LIBL.
Does the Optimizer user whatever access path it can see (attached to the
physical file), even if not in the LIBL?


[cid:image001.png@01DA2EAA.D5795E70]
_________________________________________________
If you have a support issue, please Submit a ServiceNow Ticket<
https://prysmiansd.service-now.com/sp/>

Paul E Musselman
Sr. Technical Support Analyst
IT Power Systems
North America Information Technology
[cid:image002.png@01DA2EAA.D5795E70]
Cell + 1 859 953 3134
Email: paul.musselman@xxxxxxxxxxxxxxxxx<mailto:
paul.musselman@xxxxxxxxxxxxxxxxx>
4 Tesseneer Drive
Highland Heights, KY 41076
United States



Confidentiality Notice - This message and its attachments (if any) may
contain confidential, proprietary or legally privileged information and
it
is intended only for the use of the addressee named above. No
confidentiality or privilege is waived or lost by any mistransmission.
All
reply messages and/or all attachments included, and transmitted incoming
and/or outcoming from/to the Prysmian Company could be know from its .
If
you are not the intended recipient of this message you are hereby
notified
that you must not use, disseminate, copy it in any form or take any
action
in reliance on it. If you have received this message in error, please,
delete it (and any copies of it) and kindly inform the sender, of this
e-mail, by replying or go to Prysmian site on "contact us". /// Le
informazioni contenute nella comunicazione che precede possono essere
riservate e confidenziali e sono, comunque, destinate esclusivamente
alla
persona o all'ente sopraindicati. La confidenzialit?, sicurezza e
la correttezza dei messaggi di posta elettronica non possono essere
garantite. Prysmian potrebbe avere nozione di tutti i messaggi di
risposta
e/o tutti gli allegati, alla/dalla stessa trasmessi e/o ricevuti.
Qualora
Lei non fosse la persona alla quale il presente messaggio ? destinato,
la
invitiamo a non procedere ad alcun uso, distribuzione, copiatura od
azione
ad esso conseguente. Se avete ricevuto questo messaggio per errore La
invitiamo ad eliminarlo dandocene gentilmente comunicazione rispondendo
a
questo messaggio oppure attraverso il "contact us" sul sito web Prysmian
site.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription
related
questions.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.