1.1

NLJOIN (29.93%) execute_time 17.018 ms returned_rows
594 no_opens 1
TABLESCAN (7.35%) execute_time 4.182 ms
returned_rows 518 no_opens 1 scan_qualifiers None
scanned_object APP.FLIGHTAVAILABILITY scan_type HEAP
ROWIDSCAN (9.11%) execute_time 5.184 ms
returned_rows 594 no_opens 518 node_details FLIGHTS :
INDEXSCAN (49.62%) execute_time 28.21 ms
returned_rows 594 no_opens 518 scan_qualifiers None
scanned_object FA_INDEX scan_type node_details WHERE :
((F.FLIGHT_ID = FA.FLIGHT_ID) and true)
DROP statements
Drop statements are used to drop functions, indexes, procedures, schemas, tables, triggers, and views.
DROP ALIAS
Remove a procedure result processor configuration from the SQLFire cluster.
Syntax
DROP ALIAS [ IF EXISTS ] alias-name
IF EXISTS
Include the IF EXISTS clause to execute the statement only if the specified alias exists in
SQLFire.
alias-name
The user-defined alias of the result process implementation that you want to remove. The alias
names are stored in the SYSALIASES system table.
Example
This command removes the alias "mergesort" from all server groups that host the listener:
DROP ALIAS mergesort;
DROP ASYNCEVENTLISTENER
Remove an AsyncEventListener configuration from the SQLFire cluster.
Syntax
DROP ASYNCEVENTLISTENER [ IF EXISTS ] listener-name
IF EXISTS
Include the IF EXISTS clause to execute the statement only if the specified listener exists
in SQLFire.
listener-name
Unique identifier of the AsyncEventListener configuration that you want to remove.
Example
This command removes the AsyncEventListener named "mylistener" from all server groups
that host the listener:
drop asynceventlistener mylistener;
vFabric SQLFire User's Guide502
vFabric SQLFire Reference