Tactical queries

Database
Enthusiast

Tactical queries

How to know if the tactical queries submitted are getting cached?

Tags (2)
2 REPLIES
Supporter

Re: Tactical queries

Check the CacheFlag in QryLogV

From the documentation:

Possible Values for the CacheFlag Column

T The query is found in step cache.

S The query is a parameterized query and a specific plan is generated.

G The query is parameterized query and a generic plan is generated.

A The query is a parameterized query and a specific always decision is taken. That is, each time a query is submitted using values are peeked at and the

query is parsed.

Senior Apprentice

Re: Tactical queries

dbc.QryLogV.CacheFlag

Value Description

T Query is found in step cache.

S Query is a parameterized query and a specific plan is generated.

G Query is parameterized query and a generic plan is generated.

A Query is a parameterized query and a specific always decision is taken. That is, each time a query is submitted using values are peeked at and the query is parsed.