To improve synchronization performance between Agile Manager and ALM, add indices to your ALM project schema as follows, depending on the type of database you use:
Microsoft SQL | CREATE INDEX BG_VTS_IDX ON [td].[BUG] (BG_VTS, BG_BUG_ID); CREATE INDEX RQ_VTS_IDX ON [td].[REQ] (RQ_VTS); CREATE INDEX RT_VTS_IDX ON [td].[REQ_TRACE] (RT_VTS); CREATE INDEX RT_CREATION_DATE_IDX ON [td].[REQ_TRACE] (RT_CREATION_DATE); CREATE INDEX LN_CREATION_DATE_IDX ON [td].[LINK] (LN_CREATION_DATE); |
Oracle | CREATE INDEX BG_VTS_IDX ON BUG (BG_VTS, BG_BUG_ID); CREATE INDEX RQ_VTS_IDX ON REQ (RQ_VTS); CREATE INDEX RT_VTS_IDX ON REQ_TRACE (RT_VTS); CREATE INDEX RT_CREATION_DATE_IDX ON REQ_TRACE (RT_CREATION_DATE); CREATE INDEX LN_CREATION_DATE_IDX ON LINK (LN_CREATION_DATE); |