AnsweredAssumed Answered

CA SDM Schema and Indexing question

Question asked by cdtj Champion on Oct 10, 2018
Latest reply on Oct 18, 2018 by mavitek

Hello guys!

In our env we have custom tables that growing fast and this situation forced me to thing about DB indexing using built-in technics. Here is a doc that contains everything I need to know: Schema Files Syntax - CA Service Management - 14.1 - CA Technologies Documentation. But I still have questions... Should I index all FK (SREL) attributes? Can excess index harm DB performance? Maybe some indexing tips are published that I have missed?

Also real-life examples of how you perform DB indexing in CA SDM are extremly welcome!