Bug #2094
Update DB NIMI indexes for better performance
Start date:
10/24/2011
Due date:
10/27/2011
% Done:
0%
Estimated time:
Description
Indexes were updated during the NIMI DB maintenance at 10/27/2011
It increase performance ,but issue still exist and we need to upgrade postgres up to V9.02
History
#1 Updated by Vladimir Bravov over 7 years ago
- Target version set to nimi v1_0_16
DROP INDEX switch_table_intervals_indx1;
CREATE INDEX switch_table_intervals_indx1 ON switch_table_intervals
(interval_end);
DROP INDEX switch_table_intervals_indx2;
DROP INDEX arp_table_intervals_indx1;
CREATE INDEX arp_table_intervals_indx1 ON arp_table_intervals
(interval_end);
DROP INDEX arp_table_intervals_indx3;