Overview

The SQLite ANALYZE Statement is used to update statistics about the distribution of key values in the tables. This can help the query planner to make better decisions when optimizing queries.

Syntax

The general syntax of the statement is as follows:

ANALYZE;

We can specify the table name in the statement. The ANALYZE statement is used on a specific table to update its statistics.

ANALYZE database_name;

This statement updates the statistics for the table table_name.

ANALYZE database_name.table_name;

Example

Let’s update the statistics for the emp table. Issue the following command.

/> ANALYZE emp;

 

—

SQLite Tutorials

SQLite tutorials on this website:

https://www.testingdocs.com/sqlite-database-tutorials/

For more information on SQLite, visit the official website:

https://www.sqlite.org/