I'm trying to optimize a view I have in release 9.7v8, when I add the "Optimize for 1000 rows" it throws the error "Sqlcode=-104"
the working view DML:
create view myView ( mykey ) as select mykey from user.mytable;
The non working DML:
create view myView ( mykey ) as select mykey from user.mytable
optimize for 1000 rows;
Is it possible to add an optimize option to a view? The reason I need it, is the table has grown quite large and I'm using the view to purge the table removing 1000 records at a time. With the Optimize line the results return in less than a second, with out it it takes nearly a minute. (So by having it the purge will run much much faster)
the working view DML:
create view myView ( mykey ) as select mykey from user.mytable;
The non working DML:
create view myView ( mykey ) as select mykey from user.mytable
optimize for 1000 rows;
Is it possible to add an optimize option to a view? The reason I need it, is the table has grown quite large and I'm using the view to purge the table removing 1000 records at a time. With the Optimize line the results return in less than a second, with out it it takes nearly a minute. (So by having it the purge will run much much faster)