|Subject||How to "shape" indexes to avoid index depth > 3|
In my database I have some indexes with depth = 4 (db page size is already 16KB).
The indexes are multi-segment, with the fields sequenced from least to most selective, and gstat reports a very low selectivity for the index (less than 0.00000001).
The indexed tables have between 100 million and 1500 million (yes, 1.5 Billion) rows.
All the FB articles/docs/postings that I have seen have said for performance, index depth should be no more than 3.
Any suggestions on how I can modify the indexes to get the indexes to that point?