V
V
Vyacheslav2021-01-22 15:12:19
1C-Bitrix
Vyacheslav, 2021-01-22 15:12:19

How to correctly execute the required SQL query after updating Bitrix?

After updating Bitrix version 1C-Bitrix: Site Management 20.200.700 - a message popped up on a green background in the admin header: "To improve the performance of infoblocks, you need to create an index create index ix_iblock_element_prop_val on b_iblock_element_property(VALUE(50), IBLOCK_PROPERTY_ID, IBLOCK_ELEMENT_ID) in the SQL console( link to the console)"

How to make this request correctly?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vitaliy Vayti, 2021-01-22
@SlavaZZZ

Hello.
In the same message on a green background:

To improve the performance of infoblocks, you need to create an index create index ix_iblock_element_prop_val on b_iblock_element_property(VALUE(50), IBLOCK_PROPERTY_ID, IBLOCK_ELEMENT_ID) in the SQL console (link to the console)

SQL can be found under:
Settings / Tools / SQL query

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question