Hey all, 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? Sean