Hello
There's a procedure, which replaces all user-IDs (f.e. user1 to user2). This procedure is very old and the dev is not available anymore.
Now, I should make this procedure much faster. I did some changes, but I think that I have to add some more indexes now. I know which tables need much time, but how to identify which indexes I have to add? Is there something to do in the code or just add an index and recompile the procedure?
Sorry for the stupid questions and thank you for your help!
(Version: Progress 9.1d)
There's a procedure, which replaces all user-IDs (f.e. user1 to user2). This procedure is very old and the dev is not available anymore.
Now, I should make this procedure much faster. I did some changes, but I think that I have to add some more indexes now. I know which tables need much time, but how to identify which indexes I have to add? Is there something to do in the code or just add an index and recompile the procedure?
Sorry for the stupid questions and thank you for your help!
(Version: Progress 9.1d)