1.1.1

UNIQUE (c1, c2));
INSERT INTO t1 VALUES (1, 1, 1), (2, 2, 2), (3, 3, 3), (4, 4, 4);
INSERT INTO t2 VALUES (1, 1, 1), (2, 2, 2), (3, 3, 3), (4, 4, 4);
SELECT * FROM -- SQLFIRE-PROPERTIES joinOrder=FIXED \n
t1 a, t1 b -- SQLFIRE-PROPERTIES joinStrategy=NESTEDLOOP \n
WHERE a.c1=b.c1;
statementAlias
With the following query, SQLFire uses that statement alias "My_QUERY" instead of a system-generated alias:
SELECT * FROM -- SQLFIRE-PROPERTIES statementAlias=My_QUERY \n
userTable t1 -- SQLFIRE-PROPERTIES index=IDX_COL1 \n
WHERE t1.col1 is not null;
withSecondaries
This query considers secondary buckets when joining the partitioned table with sys.members:
SELECT dsid(), count(1) from sys.members , userPartitionedTable t1 --
SQLFIRE-PROPERTIES withSecondaries=true \n
GROUP BY dsid();
withMemoryFootPrint
This query displays the complete memory footprint of tables and indexes:
SELECT * FROM sys.memoryAnalytics -- SQLFIRE-PROPERTIES
sizerHints=withMemoryFootPrint \n
;
vFabric SQLFire User's Guide282
Managing and Monitoring vFabric SQLFire