Files
notes/tiddlywiki/Generate Rebuild Index commands.txt
2026-03-12 22:01:38 +01:00

9 lines
273 B
Plaintext
Executable File

set lines 256 pages 0
select 'alter index "'|| owner || '"."' || index_name || '" rebuild online compute statistics;'
from
dba_indexes
where
owner='DRIVE' and
table_name in ('FUEL_INTERIM_TRANS_HEADERS', 'FUEL_INTERIM_TRANS_DETAILS', 'FUEL_TRANSACTION_ERRORS');