Toad World® Forums

Support for different index types

Hi everyone,

As some of you may be aware, we now support a new index type in SQL Optimizer for Oracle (Function-Based Indexes was added in v8.6) to add to support for B-Tree and Bitmap.

We would like your views on what other index types we should support in a future version of SQL Optimizer for Oracle - Reverse Key, Partitioned (Local/Global), Reverse Key, Cluster (B-Tree/Hash).

Also, should we support Index Organized Tables?

Please tell us you thoughts and views.

Thanks for your help.

John Pocknell
Product Manager - SQL Optimizer for Oracle