Speed up slow formula fields with the query optimizer

Formula Performance finds slow formulas, rollups and equations in your app and suggests fixes you can apply and roll back from General Settings.

  • Verified Nov 17, 2026
  • Classic builder

On this page
  1. Open Formula Performance
  2. Read a recommendation
  3. Apply a fix and roll it back
  4. Optimize one rollup in its field settings
  5. See how long a formula takes

Formula Performance looks at the formulas, rollups and equations in your app, finds the ones that take a long time to calculate, and suggests changes that make them faster. Some changes you apply with one click and can roll back later; others are advice you make yourself.

Open Formula Performance #

  1. Open General Settings In the builder, open Settings and click General Settings.
  2. Go to the Performance tab Click the Performance tab and scroll to Formula Performance.
  3. Run an analysis The first time, the section says the optimizer has not been initialized for this app. Click Analyze now to scan your formulas. Run it again any time to refresh the list; Last analyzed shows when it last ran.

The analysis runs in the background and does not change your live app. If it finds nothing, the section says your formulas look healthy.

Read a recommendation #

Recommendations are sorted with the most serious first. Each one shows:

  • A severity label: critical, high, medium or low.
  • What to change and why, and the field and table it is about.
  • How slow the formula has been: its worst run time and how many runs were measured.
  • View SQL change, which opens the exact database change the fix would make.

A recommendation marked Manual change — review required has no one-click fix. Read the advice and change the formula yourself, or click Dismiss to hide it.

Apply a fix and roll it back #

  1. Apply Click Apply on a recommendation. When a fix converts a field into a column the database calculates by itself, you are asked to confirm first, because it rebuilds the table.
  2. Check it The fix moves to Applied & reversible, with the date it was applied.
  3. Roll back if needed Click Roll back to undo the change. Every change is logged.
Kind of fixWhat it does
Add an indexAdds a database index so the formula finds its records faster. Index changes run online, without stopping saves.
Convert to a database columnThe database calculates the field itself whenever a record is saved. This rebuilds the table, and saves to that table wait until it finishes, which can take minutes on a large table. Apply it at a quiet time.
Rewrite a rollupCalculates the rollup for the whole table in one pass instead of once per record.

If an apply fails, the recommendation stays in the list with a note. Retry it or dismiss it.

Optimize one rollup in its field settings #

On plans with the optimizer, Rollup and Complex Formula fields have an Optimized Query switch (marked beta) in their field settings. Turn it on to calculate the rollup for the whole table in one pass instead of once per record. When you save, the new query is tested against your data; if the results differ, the field keeps its original query.

See how long a formula takes #

Formula fields show when they were last calculated, and the error if the last calculation failed. Where equation logs are turned on for your app, the Logs button at the top of a formula field's settings opens Equation Logs, with the start time, end time and duration of each run. See Equation logs.

Was this page helpful?

Something wrong or missing on this page? Tell us.