Manual index optimizations