|
By following these aforementioned best practices, you should be able to write well-organized and logical code that performs well. Specifically, index and table creation were examined, where some options were discussed to squeeze additional performance out of them. Next, code maintenance was covered, where taking a little more time up front in the coding phase can save time and make your SQL procedures more manageable later. Finally, some performance best practices for SQL and SQL PL were shown. |
|