1.1

DELETE
Delete rows from a table.
Syntax
{
DELETE FROM table-name [ [ AS ] correlation-name ]
[ WHERE Clause ]
}
Description
This form is called a searched delete, removes all rows identified by the table name and WHERE clause.
Statement dependency system
A searched delete statement depends on the table being updated, all of its conglomerates (indexes). A CREATE
or DROP INDEX statement for the target table of a prepared searched delete statement invalidates the prepared
searched delete statement.
Example
-- Delete rows from the CUSTOMERS table where the CID is equal
to 10.
DELETE FROM TRADE.CUSTOMERS WHERE CID = 10;
-- Delete all rows from table T.
DELETE FROM T;
EXPLAIN
Capture or display the query execution plan for a statement.
Syntax
EXPLAIN { sql_statement | 'statement_id' }
Description
When called with a SQL statement, the EXPLAIN command captures the query execution plan for the statement
and stores it in the STATEMENTPLANS on page 641 table. When called with a statement ID from
SYS.STATEMENTPLANS, the EXPLAIN command displays the full query plan for that statement. See Query
Plan Codes for a description of the SQLFire query execution plan codes. See Example Query Plan Analysis on
page 268 for an example that describes the query plan output.
Note: You can capture query execution plans using either a thin client or peer client connection. However,
you can display a stored query execution plan only when using a peer client connection.
As an alternative, you can capture query plans for all of the statements that are executed in a specific connection.
See Capture Query Plans for All Statements on page 268.
vFabric SQLFire User's Guide500
vFabric SQLFire Reference