Basic index questions

2002-05-29 Thread Andy Cheng
Hi, I am trying to learn about indexing and have a few questions. 1. Does index only apply to query that use = operator in the where clause? 2. Does operators such as , like and between will result to full table scan? 3. For example, In the following table: tbl_A id int primary

Re: Basic index questions

2001-11-14 Thread jim barchuk
Hi Chris! I understand that an index is used to speed stuff up, but am foggy on the details. Ayup. one of the beauties of MySQL/RDBMS is that -you- don't really need to know or -do- much except declare the index. :) I assume I set up the index like so in the create table: ... unique index

Re: Basic index questions

2001-11-14 Thread Jeremy Zawodny
On Tue, Nov 13, 2001 at 11:03:00PM -0600, Christian Stromberger wrote: I understand that an index is used to speed stuff up, but am foggy on the details. You might find this helpful: http://www.linux-mag.com/2001-06/mysql_01.html Eg, let's say I have an authors table with fname, mname, and

Basic index questions

2001-11-13 Thread Christian Stromberger
I understand that an index is used to speed stuff up, but am foggy on the details. Eg, let's say I have an authors table with fname, mname, and lname fields for first, middle and last names. Plus an auto_increment primary key. I will want to sort on author last name for output of sorted