Welcome to DynamicDrive.

To start with, much of what you are asking about does not have a "quick and easy" answer. Optimizing relational databases is a big subject and takes a long time to study...