Hello.
> it be "optimal" to use primary key + non-unique key combination to narrow
> down the search?
According to:
http://dev.mysql.com/doc/mysql/en/mysql-indexes.html
"Suppose that you issue the following SELECT statement:
mysql> SELECT * FROM tbl_name WHERE col1=val1 AND col2=va
Manoj <[EMAIL PROTECTED]> wrote on 07/14/2005 06:09:24 AM:
> Greetings,
> I am trying to get a feel of how MySQL would handle certain types of
> situation, mainly concerning the usage of indices.
>
> Say I have two exactly identical table structures namely table A &
B.
>
> For table
Greetings,
I am trying to get a feel of how MySQL would handle certain types of
situation, mainly concerning the usage of indices.
Say I have two exactly identical table structures namely table A & B.
For table A, I just have one composite primary key on (Code, Date1 &
Date2).
Fo
Greetings,
I am trying to get a feel of how MySQL would handle certain types of
situation, mainly concerning the usage of indices.
Say I have two exactly identical table structures namely table A & B.
For table A, I just have one composite primary key on (Code, Date1 &
Date2).
Fo