|
|
|
|
|
A developer at Bank of America selected SQL Insight to accomplish a seemingly impossible task, the optimization of the SQL in an entire database application containing hundreds of statements.
The developer needed not only to optimize the statements, but to identify which statements required the optimization.
Given a strict deadline to investigate and insure the optimization, supreme user satisfaction was achieved in a fraction of the time expected.
The Problem
Ever-growing business requirements and constant database structure modifications can lead a database application into drastic performance degradation.
The Global Government Banking division of Bank of America found this to be true as the complexity of one of their internal applications grew at an alarming rate.
The performance of the application became seriously impacted, forcing users of the system to wait for minutes on hand for information they required immediately.
As this downward spiral in performance became more and more unacceptable to the application's users, it became imperative that a resource be devoted purely to the optimization of the application's queries.
The Solution
The resource designated to the application's optimization chose to use Isidian® SQL Insight for the SQL comparison and detailed Explain Plan functionality.
The developer first created a visual representation of the entire application's query statistics, and was immediately able to identify which statements, throughout the entire application, were in dire need of optimization.
Using the SQL comparisons, Auto Trace, and Explain Plan functionality within SQL Insight, the developer was then able to create optimization test scenarios to determine the best timing and execution path for each statement.
The Conclusion
The developer's deadline was calculated solely on the abilities of their current set of tools.
Seeing the task complete in record time, the Global Government Banking division of Bank of America migrated their development, quality assurance, and support team to incorporating Isidian® SQL Insight as their tool of choice for SQL code generation and optimization.
|