Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Checking the Query Plan Cache

Description

The cubrid plandump utility is used to display information on the query plans stored (cached) on the server.

Syntax

cubrid plandump options database_name

options: [-d|--drop]  [{-o|--output-file=} file]

  • cubrid: An integrated utility for the CUBRID service and database management.
  • plandump: A utility that displays the query plans stored in the current cache of a specific database.
  • options: The -d and -o options are supported.
  • database_name: The name of the database where the query plans are to be checked or dropped from its sever cache.
Options

Checking the query plans stored in the cache

cubrid plandump testdb

Dropping the query plans stored in the cache (-d or --drop)

cubrid plandump -d testdb

Storing the results of the query plans stored in the cache to a file (-o or --output)

cubrid plandump -o output.txt testdb