Explain the key differences between database indexing strategies and how they affect query performance.
