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]

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

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

cubrid plandump -o output.txt testdb