I have two tables I'm doing a join with. Table1 has a PK on an id column which is Unique.<BR><BR>Table2 has a PK on two columns, uid,id which is Unique.<BR><BR>If I do a:<BR><BR>SELECT Table1.id, ...

MySQL is a powerful database, but its search capabilities are most efficient for searches based upon a single database index. If your application requires complex searching, consider adding Sphinxto ...