SQL-Optimize-Database.md

search
keywords SQL OPTIMIZE DATABASE command optimize database

SQL - OPTIMIZE DATABASE

Optimizes the database for particular operations.

Syntax

OPTIMIZE DATABASE [-lwedges] [-noverbose]

• -lwedges Converts regular edges into Lightweight Edges.
• -noverbose Disables output.

Currently, this command only supports optimization for Lightweight Edges. Additional optimization options are planned for future releases of OrientDB.

Examples

• Convert regular edges into Lightweight Edges:

  orientdb> OPTIMIZE DATABASE -lwedges
  

For more information, see

• Lightweight Edges
• SQL Commands
• Console Commands