How do relational database management systems optimize storage and retrieval operations through the implementation of various table indexing techniques, including B-trees, hash indexes, and bitmap indexes, considering their impact on query performance and resource utilization?