SQL Performance Tuning (in the Codebase): Indexes Explain how developers and DBAs can work together effectively.Provide developers with some developer-side SQL performance tuning techniques.In this article, I’d like to accomplish two things: Say the DBA team is placed on the 10th floor with all of their databases, while the devs are on the 15th floor, or even in a different building under a completely separate reporting structure-it’s certainly hard to work together smoothly under these conditions. On top of that, corporate structure can also play a role. When working with large-scale data, even the most minor change can have a dramatic impact on performance.
0 Comments
Leave a Reply. |