On 30.10.2007, at 11:01, Chuck Hill wrote:
- OR performance is bad
Yes, something odd is going on there.
If you stay inside one column with your "or" its using an index, if
you use two different columns in an or, it won't. E.g.:
select * from foo where a = 'bar' or a = 'bas';
will use an index, but:
select * from foo where a = 'bar' or b = 'bar';
will not.
cug
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]