I haven't verified this, but I understand that the "WITH" clause acts as parenthetical statements. Therefore:
SSELECT MYFILE WITH FIELD1 = "RED" OR FIELD1 = "BLUE" AND WITH FIELD2 = 4 OR FIELD2 = 6 Will result in a different selectlist than SSELECT MYFILE WITH FIELD1 = "RED" WITH OR FIELD1 = "BLUE" AND WITH FIELD2 = 4 WITH OR FIELD2 = 6 Or SSELECT MYFILE WITH FIELD1 = "RED" OR FIELD1 = "BLUE" AND FIELD2 = 4 OR FIELD2 = 6 Can anyone confirm this? Tom -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jef Lee Sent: Wednesday, September 02, 2009 3:42 AM To: [email protected] Subject: [U2] Performance query Can anyone shed light on which is better: SSELECT MYFILE WITH FIELD1 = "RED" AND FIELD2 = "BLUE" or SSELECT MYFILE WITH FIELD1 = "RED" AND WITH FIELD2 = "BLUE" Does it make a difference if one or both are indexed. Thanks... Jeffrey Lee Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000 F: (08) 9315 7088 W: http://www.itvision.com.au ___________________________________________________________ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___________________________________________________________ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
