CODEWITHSUNDEEP
sqlsybasesap-iq
Blazen
Blazen

Reputation: 322

Remove Execution plan cache from Sybase IQ

how can I remove execution plan cache for a specific query from sybase iq

Upvotes: 0

Views: 1003

Answers (1)

Mike Gardner
Mike Gardner

Reputation: 6651

You should be able to change the setting for max_plans_cached option to 0 to disable the caching of plans. When reenabled, the optimizer should recompute the plans as the queries are executed.

This is a good description of the plan caching methods in SQL Anywhere 12, which should be fairly close to the same in IQ.

Upvotes: 1

Related Questions