9 lines
273 B
Plaintext
9 lines
273 B
Plaintext
|
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');
|
||
|
|
|