Indexing?

Anyone got a great reference that explains what fields to index.. etc..

Would you index your foreign keys, or since the key of the referenced table is indexed should I not?

In almost all cases, Foriegn Keys should be indexed.