Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Re: OT: Indexes in MySQL

by monarch (Priest)
on Jan 20, 2009 at 21:19 UTC ( [id://737679]=note: print w/replies, xml ) Need Help??


in reply to OT: Indexes in MySQL

Please see the MySQL document page on multiple column indexes.

Essentially performance for the single combined index vs two separate indices (not sure why they are referred to as indexes) is the same when you query using the first key or both keys.

The combined index is only effective if you don't plan on attempting to query using only the second key. Order of keys is important in a combined index.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://737679]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (3)
As of 2024-04-25 21:07 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found