When considering index sorting would it be correct to assume the following cost/benefits:
- faster searching for standard queries
- Better index compression
- Significantly reduced indexing throughput, sort parameters depending.
- In general, better suited to read heavy workloads
Also, index sorting was introduced in 6.0. Has the efficiency of index sorting moved on significantly since then?