Hello.
If you make composite index on all fields you'll be able to use it in searchings only on left-most prefixes of the key. You should make a separate index for each field if you want to search on each field, however, many indexes will slow down inserts to the table. Andy Pieters wrote: > Hi list > > I have a data set that is composed of many fields (30+). The final app will > allow the users to search records on each field. > > What is the best thing to index in this situation? Make an index for *all* > fields? > > With kind regards > > > Andy > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
