Having different Table space for different indexes of same table, will causes any performance impact

indexoracle

Table Master_Table is created in App1_Schema1.
Index_I01 is created in default TABLE SPACE.
Index_I02 is created in TABLE SPACE "APP2_INDEX".

Having different Table space for different indexes of same table, will causes any performance impact ?

Best Answer

Placing the indexes for a table in the same or different tablespaces from the tables and other indexes on the same table should have no impact on performance unless you have done something very wrong with your disk farm.