Q
Problem solve Get help with specific problems with your technologies, process and projects.

Rebuilding indexes on temp tables

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close