> Also an index is nothing more than a partial copy of a table with a different key. It denormalizes you data. Do you use indexes other than pk?

The relational model distinguish between the logical and physical levels. Normalization applies to the logical level. At the physical level you can have duplicate data, e.g. caches, which is fine as long as the engine guarantee consistency of the logical model.