Explain the concept of database indexing, including the trade-offs between B-Tree indexes and Hash indexes.