All Forums Database
Kishore_1 208 posts Joined 03/10
07 Aug 2014
Tactical queries

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

ulrich 816 posts Joined 09/09
07 Aug 2014

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.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

dnoeth 4628 posts Joined 11/04
07 Aug 2014

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.

Dieter

You must sign in to leave a comment.