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
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
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
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