Latest Activity

code

Query timeout that considers time to generate plan

Hi there, We would like to find a way to limit the duration a query can run. But we need this time limit (e.g. 15min) to consider the time to generate the execution plan. To my understanding, there is a default 15min timeout, but this only starts coun...

execution plan timeout

code

Fetch plan of the query cache

Hello. I work with a cache for views. And faced with strange behavior. When I am disabled the cache for a view, the execution time amounted ~50ms. When I am enabled partial cache, the execution time amounted ~400ms. I need opportunities for fetching p...

execution plan cache

code

How can I obtain the execution plan before executing the query from VQL Shell.

When I execute a complex query from VQL Shell , I want to know what is the execution plan that Virtual DataPort will use to run the query . How can I obtain the execution plan before executing the query from VQL Shell.

execution plan