What’s the role of indexing in database performance?

How do you set up and maintain indexes for faster database queries?