Explain how database indexing works in relational databases and how it compares to vector indexing in vector databases.