Toad World® Forums

Indexes and partitioning


If you’re dealing with Global indexing or Index Expert in partitioned environments, is that configuration taken into account when the indexes are generated? In other words, will it suggest indexes properly when partitioning is involved.


Currently, we didn’t provide any option when generating index with partitioning option, and we would like to keep the flexibility with user. My idea is to provide an interface, and let user to try the difference options with a manual index generator. About the auto one, it could focus at the selecting of complication columns’ selectivity. However, the manual index generator interface is still in planning and not implement yet. It could be happened at a few more version later.


Althrough we cannot provide partition index, but if the new index on the partition table can generate new plan with different cost, this new index will be considered as a index candidate.