Ways to optimize Database queries

1. Indexing
2. using Explain

There are many other ways, Please add them in your comments.