Use Proper Indexing: Ensure frequently used columns are indexed.?

Review the concept and prepare a concise verbal explanation with a real project example.