How relevant are database b-tree based indexes in the face of SSD since they were originally built keeping HDD in mind?
Wanted to understand if databases automatically detect the underlying hardisk type (HDD/SSD) and optimize or if we need to provide some hint to this effect?