It is best to use an IOT when you only query the table's contents by specifying the primary key in the WHERE clause.
If you query other, non-PK columns in the WHERE clause, you may find the IOT will slow down your performance.
The only way to know for sure if the IOT will work in your Oracle environment is to test it out with your application.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.