Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Databases General > Re: One example...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 8 of 9 Topic 3196 of 3269
Post > Topic >>

Re: One example of a slow query.

by Ed Prochak <edprochak@[EMAIL PROTECTED] > Jun 25, 2008 at 05:09 AM

On Jun 25, 4:13 am, David Segall <da...@[EMAIL PROTECTED]
> wrote:
> "David Cressey" <cresse...@[EMAIL PROTECTED]
> wrote:
> > Because
> >there was an index with a compound index key,  namely country, state,
and
> >city.
>
> Why would you do that instead of indexing the fields separately?

Better is one index defines as city, state, country.
Put the most discriminating element first. then partial searches on
that index still work.
  Ed
 




 9 Posts in Topic:
One example of a slow query.
"David Cressey"  2008-06-24 18:18:08 
Re: One example of a slow query.
David Segall <david@[E  2008-06-25 09:13:38 
Re: One example of a slow query.
"Roy Hann" <  2008-06-25 11:12:55 
Re: One example of a slow query.
"Arved Sandstrom&quo  2008-06-25 11:55:34 
Re: One example of a slow query.
Thomas Kellerer <YQDHX  2008-06-25 14:16:23 
Re: One example of a slow query.
"David Cressey"  2008-06-25 14:13:42 
Re: One example of a slow query.
"David Cressey"  2008-06-25 14:10:37 
Re: One example of a slow query.
Ed Prochak <edprochak@  2008-06-25 05:09:24 
Re: One example of a slow query.
Ed Prochak <edprochak@  2008-06-25 05:16:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Oct 11 12:21:32 CDT 2008.