I would like to know if an index on a "temp" table ("Z_xxx" table) needs to be rebuilt if it is listed in "Tablespace Analysis Report" as fragmented? I ran the "Tablespace Analysis Report" on the tablespace that holds our indexes for our Oracle 8173 production database, and under the "Space Alerts and Warnings" section there were a few indexes that are part of "temp" tables that were marked as "Index suffering from Fragmentation". Does it make sense to rebuild an index on table that has a 0 row count? Or should I just rebuild it to clean up this report? Let me know what you think.
Is this a "true" temporary table, i.e., a global temporary table (GTT)? I suspect it is not, since all temporary table and index segments reside in the owner's temporary tablespace. If it's not a GTT, go ahead and rebuild; with 0 rows it should take almost no time.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.