1c-query-optimization

Replace subqueries in SELECT or JOIN clauses with temporary tables. Write the aggregated or filtered data into a temporary table with ПОМЕСТИТЬ, add ИНДЕКСИРОВАТЬ ПО on join fields, then join the main query against it.

Pass filter conditions as virtual table parameters instead of using WHERE after the table. For example, Остатки(&Дата, Номенклатура В (&Список)) filters at the source, while a WHERE clause forces the platform to materialize all rows first.

Dereferencing a composite reference like Регистратор.Дата makes the platform generate queries for every possible document type. Use ВЫРАЗИТЬ to cast the field to one concrete type, or ВЫБОР/КОГДА with ССЫЛКА checks for a few known types.

Use ОБЪЕДИНИТЬ ВСЕ when duplicate rows are not expected, because plain ОБЪЕДИНИТЬ performs an extra grouping pass to remove duplicates. Reserve ОБЪЕДИНИТЬ only for cases where deduplication is actually required.

OR conditions prevent index usage, forcing full table scans. Split the condition into separate indexed queries combined with ОБЪЕДИНИТЬ ВСЕ so each branch can use its own index.

For basic query rules like formatting, aliases, parameters, and avoiding queries in loops, use the base coding standards document instead. This skill covers only advanced patterns beyond those fundamentals.