1c-query-opt

To optimize slow 1C:Enterprise queries, restructure JOIN and subquery patterns, push filters directly into virtual table parameters using ИЗ ... ПАРАМЕТРЫ, and extract intermediate results into temporary tables with proper indexing.

1C virtual table queries perform poorly when filters are applied after data retrieval instead of being pushed into virtual table parameters, causing the platform to process unnecessary post-filtering on large datasets.

Use temporary tables instead of complex subqueries in 1C when you need to stabilize the query shape for the optimizer, applying INDX and INNDXATION strategies to improve multi-step data processing performance.

ОБЪЕДИНИТЬ removes duplicate rows while ОБЪЕДИНИТЬ ВСЕ retains all rows, and choosing the correct UNION strategy carefully stabilizes the query shape and prevents inefficient execution during СКД report tuning.

Handle composite types safely in 1C query optimization by explicitly expressing them in the query structure and using presentation for display, which stabilizes the query shape for the platform's execution model.

You can fix N+1 query patterns by replacing problematic joins with temporary tables and restructuring JOIN usage to better fit the 1C:Enterprise execution model without altering the intended business result.