> It's not going to speed everything up, just certain select statements. And > quite honestly, it's going to speed up certain select statements that are > not really kosher. > > For example, if your application is full of select statements like SELECT > FILE WITH @ID = "ABCDEF", then you should probably re-write the statement to > something like SELECT FILE "ABCDEF".
What about this? SELECT FILE WITH @ID LIKE ABCDEF... or, in Pick style SELECT FILE EQ 'ABCDEF]' Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group 717-545-6403 tsnyd...@us.ibm.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/