Related Posts
What is comp like at a pension fund?
Any suggestion is appreciated.

Additional Posts in Technology/IT Consultants
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
What is comp like at a pension fund?
Any suggestion is appreciated.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Download the Fishbowl app to unlock all discussions on Fishbowl.
Copy and paste embed code on your site

Scan your QR code to download
Fishbowl app on your mobile

A human.
Tools can check indexes and various other things. A lot of the rest depends on the types of queries you’re running.
There are tools which can scan databases and report the performance, especially about index design. But there is no tool to recommend about data model design. That depends on what you are using the database for and so can be handled only by a data modeler. Erwin is a popular data modeling tool to reverse engineer a database and show you via an ER diagram the data model (logical model) . A good modeler can scan the ER diagram and grade the database design.
Coming to other design (physical models) that includes indexes, physical storage, performance etc, Every database vendor provides very sophisticated management tools that monitor, collect metrics to point at performance issues before they grow and recommend changes. These tools are usually owned and operated DBAs or Systems folks. They can give you a comprehensive report. Example is Oracle Enterprise Manager (OEM) for Oracle databases.
Speaking of tuning SQL queries, the same tool above can collect the stats, come up with “explain plan” to show how expensive each of the queries are and recommend indexing and how to rectify the query to make it faster.
There is no one AI tool to do it all ... yet.
TOAD is one of the better tools that a lot of DBAs use, but it is mostly for optimizing indexes and queries, not the other things. Normalization might be something you could objectively assess, but denormalization is usually done for optimization and highly dependent on how the database is used. Programmability and relationships are much more subjective once you get out of pure query optimization.
For query optimization though, TOAD can seem like magic. I’ve seen a DBA run it on a query and have it spit out a solution in a few minutes that increased performance 100x.
I agree with Partner 1 as a human is the best performance test for a database. I have seen the best database design be brought to its knees over some bad application code. TOAD can give you some good statistics. The real test is the User pushing the button on the app and the results return in a few seconds or take forever.
Normalize until it hurts. 6NF for life! 😂