Hi Eve: Indexing is use to speed up search in the tables. You can have Primary Key Index to force unique key ( Ex: Client_Cod), or normal index in columns you use to get data in an alternate way(Ex: Client_Name). If you have very little data in your tables, the speed will not notice the speed but as data grows, you start to notice the gain in the searches.
You need to read a book on Relational Database. Osvaldo Sommer -----Original Message----- From: Eve Atley [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 8:42 PM To: [EMAIL PROTECTED] Subject: More on indexes? Hi, I've been following the list to get a better grip on MySQL, and have been hearing a lot about indexing. I'm beginning to think I should have indexed some of my tables in the past. Can anyone point me in the right direction as to the purpose of indexes, why they are used, the benefits, and when one should index? Thanks, Eve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.605 / Virus Database: 385 - Release Date: 3/1/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.605 / Virus Database: 385 - Release Date: 3/1/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]