Jul 21, 2020 11:45:00 AM by Gary Jerep
Part three in a blog series about SQL optimization, index tuning and yes … the quiz answers!
At the end of my previous blog post, I gave you a pop-quiz. Remember the scenario? You have five small tables, and each table has only three columns. That’s it. For simplicity’s sake, I’ll keep the answers short here, but see the forum thread discussion here, where you’ll see others’ quiz responses, and where I get into more details regarding calculations and practical considerations. What were the questions again?
What’s the real point of the quiz? Simply this: most of us don’t realize how super difficult it really is to identify an effective set of indexes for the way your applications access database tables.
Develop your own applications in-house? Purchase vendor-supplied solutions? Either way, you’re sure to have more than five small database tables, and you’re going to need some super-duper uber-intelligent assistance to find the ultimate set of indexes to make your applications hum. Quest® SQL Optimizer, has that uber-intelligence. Plain and simple.
Remember Alex from my previous post? Here were his challenges. And here’s how Quest SQL Optimizer overcomes each of these.
Quest SQL Optimizer has parsers that can search for SQL in:
You took the quiz. You’ve seen the numbers. This task is humanly impossible. But when you feed your workload to SQL Optimizer’s Index Analyzer, the product employs AI techniques and smart genetic algorithms to rapidly find feasible sets of candidate indexes. And it does this exponentially faster—literally!—than the best consultants your money can afford.
The screen capture below shows how SQL Optimizer finds several index sets only mere seconds after the search starts. Other index sets are discovered at other points in time. In minutes!
SQL Optimizer can use virtual indexes to assess the performance impact of proposed indexes on your SQL workload, as the screen capture below shows.
So there you have it, a one-two-three punch. Plain and simple. Quest SQL Optimizer can:
Try SQL Optimizer for Free
SQL Optimizer is included in many of our Toad elite editions like Xpert, Dev and DBA, and not just for Oracle, but also for SAP and Microsoft SQL Server. If you’re already using a Toad product, check to see which edition you have and consider upgrading. Or, try SQL Optimizer out for free.
Add on data modeling, code analysis, and code testing in this free trial
Besides SQL Optimizer, do you need more features like data modeling, code analysis, and code testing? Compare our top three Toad for Oracle editions and try Toad free for 30 days. Are you already in a trial and ready to purchase? Talk to sales or buy now online.
Quest Software is here to help you simplify complexity, reduce cost and risk, and drive performance. Maybe that’s why we’re consistently voted #1 by DBTA readers and have 95%+ customer satisfaction rate.
Toad® database management tools are cross-platform solutions from Quest® that can help new and veteran DBAs, and even “accidental” DBAs manage data in Oracle, SQL Server, DB2, SAP, MySQL, and Postgres environments.
Learn more about how Toad database management tools from Quest can help with database development, performance monitoring and database DevOps.
If you think your colleagues would benefit from this article, share it now on social media with the buttons located at the top of this blog post. Thanks!
Written by Gary Jerep
As a Software Consultant within Quest, Gary Jerep has over 20 years of experience assisting DBAs, Developers and Analysts with relational database needs. Prior experience includes systems design and analysis, operations research, Business Intelligence, and end-user experience monitoring.