1. TARGIT Community
  2. Documentation
  3. Data Warehouse: TARGIT InMemory
  4. System Specific Tables and Objects

INFORMATION_SCHEMA.QUERY_LOG

Avatar
Ole Dyring

Shows a list and stats on recently run queries. By default, the query_log is turned off. You can enable the log by running the sql statement SET querylog = 1000, and the most recent 1000 queries will be logged. You can disable it by running SET querylog = 0.

Example:

SELECT * FROM INFORMATION_SCHEMA.QUERY_LOG
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Articles in this section