文の入力サイズは、問合せの評価時間の長さに大きな影響を与えることがあります。
文の入力は、FROM句で定義されます。可能であれば、コレクションのレコードではなく、完了した別の文からの結果を使用してください。これは、不要なレコードが入力されるのを防ぐためです。
DEFINE Sums AS SELECT SUM(a) AS MonthlyTotal FROM SaleState GROUP BY month,year; DEFINE Totals AS SELECT SUM(a) AS YearlyTotal FROM SaleState GROUP BY year; DEFINE Result AS SELECT Sums[month,year].MonthlyTotal AS MonthlyTotal, Sums[month,year].MonthlyTotal/Totals[year].YearlyTotal AS Fraction FROM SaleState GROUP BY month,year
DEFINE Sums AS SELECT SUM(a) AS MonthlyTotal FROM SalesState GROUP BY month,year; DEFINE Totals AS SELECT SUM(MonthlyTotal) AS YearlyTotal FROM Sums GROUP year; DEFINE Result AS SELECT MonthlyTotal AS MonthlyTotal, MonthlyTotal/Totals[year].YearlyTotal AS Fraction FROM Sums
DEFINE Constants AS SELECT 500 AS DefaultQuota FROM SaleState GROUP
DEFINE Constants AS SELECT 500 AS DefaultQuota FROM SaleState WHERE FactSales_ProductKey IS NOT NULL GROUP
例では、FROM SalesStateはSalesコレクションの一意のプロパティ・キーです。