Jeffrey, In our findings, using UV 10.1.16 and below in Pick flavor the connecting word WITH is mandatory. Only the first field found to be in an index will be used to read the index If we want both to be used we use a correlative, although that needs special care since indices are only updated when real fields are changed.
My 2 (euro)cents Arie van Dam -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jef Lee Sent: woensdag 2 september 2009 9:42 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
