Is index rebuilt upon updating table with the same values as already existing in the table?

Поиск
Список
Период
Сортировка
От Zeev Ben-Sender
Тема Is index rebuilt upon updating table with the same values as already existing in the table?
Дата
Msg-id 217DDBC2BB1E394CA9E7446337CBDEF2A8889B1A12@il-ex01.ad.checkpoint.com
обсуждение исходный текст
Ответы Re: Is index rebuilt upon updating table with the same values as already existing in the table?
Список pgsql-general

Hi,

 

Having the update statement like this:

UPDATE my_table SET (COL1 = ‘05cf5219-38e6-46b6-a6ac-5bbc3887d16a’, COL2 = 28) WHERE COL3 = 35;

 

Will this statement result indexes rebuild if COL1 and COL2 already equal ‘05cf5219-38e6-46b6-a6ac-5bbc3887d16a’ and 28?

 

Thank you

 

В списке pgsql-general по дате отправления: