* Andy Cheng
> 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?
No.
> 2. Does operators such as >, like and between will result to full table
> scan?
No. LIKE "%whatever%" will not use the index, but LIK
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 key
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, mna
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
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
aut
