Show pagesource
•
Recent changes
•
Login
Switch to:
V9
•
V8
•
V7
•
V6
•
V5
/
valentina
/
vcomponents
/
vsql
/
reference
/
defragment
Valentina Compound Statement Syntax
Valentina SQL Expression
Properties
SELECT Statement
SHOW Statements
ALTER EVENT
ALTER LINK
ALTER TABLE
ALTER TRIGGER
ALTER TYPE
ALTER VIEW
BACKUP DATABASE
CALL
CLONE DATABASE
COMPACT
COPY LINKS
CREATE DATABASE
CREATE EVENT
CREATE INDEX
CREATE KEYVALUE
CREATE LINK statement
CREATE PROCEDURE/FUNCTION
CREATE SEQUENCE
CREATE TABLE
CREATE TRIGGER
CREATE TRIGGER on DB
CREATE TRIGGER DDL
CREATE TRIGGER DML
CREATE TYPE
CREATE USER
CREATE VIEW
DEFRAGMENT
DELETE
Description of Valentina SQL Grammar Rules
DIAGNOSE
DROP CONNECTIONS
DROP DATABASE
DROP EVENT
DROP INDEX
DROP KEYVALUE
DROP LINK statement
DROP PROCEDURE/FUNCTION
DROP SEQUENCE
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP USER
DROP VIEW
EXECUTE
GRANT PRIVILEGES
INSERT INTO
LINK/UNLINK Records
KEYVALUE DELETE
KEYVALUE GET
KEYVALUE INSERT
KEYVALUE UPDATE
KEYVALUE UPSERT
LEXICAL TOKENS
MAIL
MERGE
PIVOT TABLE
PRINT
HIERARCHICAL (RECURSIVE) QUERIES
REGISTER DATABASE
REGISTER PROJECT
REINDEX
REPORT Statement
REVOKE PRIVILEGES
SET PASSWORD
KEYWORDS
TRUNCATE
UNREGISTER DATABASE
UNREGISTER PROJECT
UPDATE
USE DATABASE
Table of Contents
DEFRAGMENT
Syntax
Description
DEFRAGMENT
Syntax
compact : DEFRAGMENT
Description
This command removes the fragmentation in the Database:
it defragments segments of the Database files.
it defragments pages of Indexes and VarChar fields.
© 1998-2019 Paradigma Software Inc. All rights reserved.
valentina/vcomponents/vsql/reference/defragment.txt · Last modified: 2019/02/12 11:33 by rz