Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
query performance problems
no - the change doesn't reduce the time, because the optimizer changes it to the WHERE clause already :( OK - here is the explain output, I reduced the queries a bit, problem still exists, but it's a bit less output (but still a lot) ------- QRYBEAHALF1 ----- SELECT B.FKSSTATUS... -
query performance problems
sorry, GROUP BY was only left, because the original query did some aggregates, I forgot to remove it writing this easier example. Anyway -> when replacing it by SORT BY times changes but these big time differences still exist. By the way: timing is done by db2batch (several times and average... -
query performance problems
I do have some problems concerning a query, which looks like the following: -------------- select a.ATTSTATUSTEXT, a.PKCSTATUSKRZL, [...] b.ATTNAME as ANFORDERERNAME, c.ATTNAME as ERSTELLERNAME from WSBEAAPP.QRYBEAHALF as a JOIN ORGAPP.TBLCSGDIR as b ON... -
word ole
Hi I try to create a WordDocument which should be save in a NotesDocument and filled by various data. Unfortunataly I just can't print any text into the WordDocument. That's the code I've written (in PostOpen): If Source.IsNewDoc Then Set rtItem=New...
