Project

General

Profile

Bug #2094

Update DB NIMI indexes for better performance

Added by Vladimir Bravov over 7 years ago. Updated over 7 years ago.

Status:
Assigned
Priority:
Normal
Target version:
Start date:
10/24/2011
Due date:
10/27/2011
% Done:

0%

Estimated time:
Duration: 4

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;



Also available in: Atom PDF