ncc:tldr:93675

ncc: Clean the `ncc` cache.

$ ncc clean cache

try on your machine

The command "ncc clean cache" is used to clean the cache of the Netezza compiler (ncc).

In Netezza, the ncc compiler compiles the SQL statements and generates an execution plan for query execution. The compiled SQL and execution plans are stored in a cache to improve the performance of subsequent similar queries.

However, over time, the cache can become bloated with outdated or unnecessary compiled SQL and plans, which may negatively impact performance. Therefore, the "ncc clean cache" command is used to remove the contents of the cache and start fresh.

When you execute the command "ncc clean cache", it will delete all the compiled SQL and plans stored in the cache. This will force the Netezza system to recompile the SQL statements and generate new execution plans when those queries are executed again.

This explanation was created by an AI. In most cases those are correct. But please always be careful and never run a command you are not sure if it is safe.

back to the ncc tool