Question: Flowfield Performance Key

nav_student

Hi guys,

A newbie question about FlowField performance (Native database).

On the Customer table I have this field:
Field: Balance
Type: Decimal
FieldClass=FlowField;
CalcFormula=Sum("Detailed Cust. Ledg. Entry".Amount WHERE (Customer No.=FIELD(No.),
Initial Entry Global Dim. 1=FIELD(Global Dimension 1 Filter),
Initial Entry Global Dim. 2=FIELD(Global Dimension 2 Filter),
Currency Code=FIELD(Currency Filter)));


Question:
For the best performance possible do I need to have the exactly this Key:
- Customer No., Initial Entry Global Dim. 1, Initial Entry Global Dim. 2, Currency Code
setup on the table Detailed Cust. Ledg. Entry, related to the Amount field?

Thanks for your help!

tothszabolcs

hello,

yes, you need to add that key to "Detailed Cust. Ledg. Entry" table, after that add Amount field in SumIndexFields column.

After this setup you will get better runtime.

bbrown

Remember that it will use the first key that contains all the fields on which you are filtering and has the proper SuMIndexField. So if there is a key, above the one you create, that also has those same fields, then it will use that key. Even if it contains additional fields.