Indexes are the core element of your database navigation. Use them to map the different types of data in your database, so that you don’t need to parse all the records to find a match. NB You have to ...

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, ...