Re: General Questions About Indexes

2007-05-28 Thread Baron Schwartz
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

2007-05-27 Thread John Kebbel
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