Are constraints also indexes, or would you want an additional index on top of a constraint if you wanted that column/combo indexed?
No, having a constraint does not imply that an index exists. However, the enforcement of a "unique" constraint is implemented by auto-creating a unique index.
