G
gus bjorklund
Guest
note that aside from the ordering available by the key. each index can have a radically different i/o cost, as much as 500 to 1 difference, depending on the blocks where the rows are stored as well as the (less important) seek time between index blocks. this cost should be measured (probably again when significant changes happen to storage arrangement) on each deployed system.
Continue reading...
Continue reading...