Mailing Lists: Apple Mailing Lists

Image of Mac OS face in stamp
 
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database choices



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      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden
References: 
 >Re: Database choices (From: Ricardo Parada <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)
 >Re: Database choices (From: "John Huss" <email@hidden>)
 >Re: Database choices (From: Chuck Hill <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2007 Apple Inc. All rights reserved.