Now that I have got your attention with my sales pitch. Let me quote a sales pitch we have heard…
Tag Indexes
spool index_rebuild.sql select ‘alter index ‘||owner||’.’||index_name ||’ rebuild online nologging;’ from dba_indexes where owner=upper(‘SAMPLE’); spool off
How to drop all indexes in a SCHEMA –Login as the schema user whose indexes you want to drop SQL>set…
Index Re-building is a debatable concept amongst DBA’s. Experts like Ask Tom think rebuilding indexes doesn’t create any considerable performance…