CODE EXAMPLE FOR SHELL

sqlite analyze table

#Show all databases conected
sqlite> .databases
main: /home/ubuntu/db.sqlite

# Enable stats
sqlite> .stats on

# Analise all
ANALYZE;

# Analise one table
ANALYZE main.users;