> > Notice the index is only on OPERATOR_CODE, not on BRANCH_CODE and
> > OPERATOR_CODE, the two primary key fields. Is this intended?
>
> Primary keys are implicitly indexed (at least, by both MySQL and
> Oracle). The additional index which is created is to provide faster
> searching for the case when your WHERE clause contains only
> OPERATOR_CODE. See MySQL's documentation on the EXPLAIN command for
> more information, or Table's doHeavyIndexing() method in
> jakarta-turbine-torque.
Ok, that makes sense, and I know it is the way Oracle works. I wasn't
sure whether MySQL generated indexes automatically for the primary keys.
Thanks for the information!
> Daniel
--
Gonzalo A. Diethelm
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
