Poorly performing code should be thoroughly documented before we undertake a rewrite. It is easy to start grabbing and rewriting code only to get bogged down in nested if statements, while loops, or calls to other SQL objects. If we have an understanding of the desired functionality, as well, we can make the determination whether the current code should be refactored or if we should just start from scratch.
Incorporating Existing Documentation
We can start with the code. If we don’t have any additional documentation, we’re going to need to figure out the functionality from the code itself. ...
