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
