If this is UV, try the two sentences with the EXPLAIN qualifier appended...
SSELECT MYFILE WITH FIELD1 = "RED" AND FIELD2 = "BLUE" EXPLAIN This will tell you the strategy UV is using for the query. Thanks, Ross. On Wed, Sep 2, 2009 at 12:42 AM, Jef Lee <[email protected]> wrote: > 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. > > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
