wie kann ich die Intex aller Tabellen neu setzen.
Was ich bis jetzt versucht habe und leider nicht geht
Code: Alles auswählen
execute block
AS
declare variable ix varchar(255);
begin
for select rdb$indices.rdb$index_name from rdb$indices
into ix
do
execute statement 'SET STATISTICS INDEX '||ix ;
end
Code: Alles auswählen
SQL Error [335544634] [42000]: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 1; begin [SQLState:42000, ISC error code:335544634]
SQL Error [335544634] [42000]: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 1; begin [SQLState:42000, ISC error code:335544634]
SQL Error [335544634] [42000]: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 1; begin [SQLState:42000, ISC error code:335544634]
SQL Error [335544634] [42000]: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 1; begin [SQLState:42000, ISC error code:335544634]
Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 1; begin [SQLState:42000, ISC error code:335544634]
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 1
begin
Wer hat schonmal die Index neu gesetzt?
Gruss & Danke