See: http://www.mysql.com/doc/C/R/CREATE_INDEX.html http://www.mysql.com/doc/M/y/MySQL_indexes.html
Steve Meyers > -----Original Message----- > From: Michael [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 2:07 PM > To: [EMAIL PROTECTED] > Subject: indexing question > > > Can anyone give me some tips on how indexes work? > > I noticed that UNIQUE() seems to create a lock on all given fields per > call like UNIQUE (md5, mime) so that no row can have the same combination > of md5 and mime type which is good but assuming I wanted to have each > unique on it's own I'd need UNIQUE (md5), UNIQUE (path) right? > > Are INDEX's the same as KEY's? When I INDEX() something it seems to dump > as a KEY(). Does it matter if you INDEX ( path, md5, mime ) or > INDEX(path), INDEX(md5), INDEX(mime)? They seem to look different in the > db depending how I do it but both seem to run at about the same speed even > over a large db. Either is a huge speed increase over the original that > had only primary keys it seems. > > Right now in a db with several tables.. some with hundreds of thousands of > rows.. the average query time seems to be about half a second to a second > on a P133. Is that good, bad, or normal? > > *^*^*^* > Michael McGlothlin <[EMAIL PROTECTED]> > http://mlug.missouri.edu/~mogmios/projects/ > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php