文の入力サイズは、問合せの評価時間の長さに大きな影響を与えることがあります。
文の入力は、FROM句で定義されます。FROM句が存在しない場合の入力のデフォルトは、NavStateRecordsです。可能であれば、コーパスのレコードではなく、完了した別の文(または指定した状態)からの結果を使用してください。これは、不要なレコードが入力されるのを防ぐためです。
DEFINE Sums AS SELECT SUM(a) AS MonthlyTotal GROUP BY month,year; DEFINE Totals AS SELECT SUM(a) AS YearlyTotal GROUP BY year; DEFINE Result AS SELECT Sums[month,year].MonthlyTotal AS MonthlyTotal, Sums[month,year].MonthlyTotal/Totals[year].YearlyTotal AS Fraction GROUP BY month,year
DEFINE Sums AS SELECT SUM(a) AS MonthlyTotal 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 GROUP
DEFINE Constants AS SELECT 500 AS DefaultQuota WHERE "mdex-property_Key" IS NOT NULL GROUP