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!