The REPLAN hint forces resampling and replanning for a query.
When you run prepared queries on a database that can change significantly due to a large number of deletes or similar events, it is possible that, because the plan was created for a different situation, it is no longer appropriate for the query and the replanning triggers are not reached. Use the REPLAN option to force query replanning.
solidDB hint proprietary format
Instead of the SQL standard format, you can use the following solidDB proprietary hint format, which is not nested into comments and is not part of the SQL standard:
HINT BEGINhintHINT END
For example, instead of the following statement:
SELECT --(* vendor(solid),product(engine), option(hint) -- REPLAN *)-- * FROM TABLE_1, TABLE_2 WHERE TABLE_1.ID = TABLE_2.ID;
you could use:
SELECT HINT BEGIN REPLAN HINT END * FROM TABLE_1, TABLE_2 WHERE TABLE_1.ID = TABLE_2.ID;