Re: Database choices
Re: Database choices
- Subject: Re: Database choices
- From: Guido Neitzer <email@hidden>
- Date: Tue, 30 Oct 2007 12:18:13 -0600
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:
This email sent to email@hidden