Re: General Questions About Indexes

Hi John, John Kebbel wrote: INDEXES - A Science AND an Art I've been continuing to look for answers to my own questions. I've found a few ... I meant to write back and try to help, but got busy with other things. You have found some good answers for yourself. Q1. What good does it do to s

Re: General Questions About Indexes

INDEXES - A Science AND an Art I've been continuing to look for answers to my own questions. I've found a few ... Q1. What good does it do to store the primary key or a unique key if you're normally SELECTing columns that don't use that primary or unique key? "As you can see, it only make

General Questions About Indexes

I have a few questions about indexes. I understand (1) what an index is, and (2) why indexes are useful, but I don't have even a rough idea about HOW they work. The internet resources I've been able to find don't answer the questions I'm asking. I also tried cat /var/lib/mysql/srms07/staff.