DX NetOps Manager

Expand all | Collapse all

Add an Index to a the CAPC netqosportal DB

Jump to Best Answer
  • 1.  Add an Index to a the CAPC netqosportal DB

    Posted 01-23-2018 11:16 AM

    How do I request the CAPC Development team to add an Index to the the CAPC DB (netqosportal)?

     

    ALTER TABLE `dst_interface` ADD INDEX `SourceID` (`SourceID`);

     

    The Source ID should be indexed and is causing many of my queries to lag significantly. So, I add the index myself, but then after an upgrade it goes back to how it was. Can it just be permanently indexed please?



  • 2.  Re: Add an Index to a the CAPC netqosportal DB
    Best Answer

    Posted 01-23-2018 07:54 PM

    Please create an idea for this ...that's the way to get the information to be reviewed by CA PC Dev or PM