TrustRadius Insights for Toad Database Developer Tools are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.
Pros
GUI interface: The GUI interface of Toad for Oracle is highly praised by users, who consider it to be the best in its class. They find it easy to learn and get used to.
Performance monitoring capabilities: Users appreciate the performance monitoring capabilities of Toad for Oracle, which allow them to effectively monitor database performance and long running transactions. It is preferred over native tools like SQLPLUS or OEM for most performance issues.
Data modeling features: The data modeling features in Toad for Oracle are highly regarded by users. They find it easy to develop data models for their database design and generate scripts to create objects in the database instance. Users particularly value the ability to utilize features like SQL Loader, Export/Import, etc. with ease.
Toad for Oracle is used to connect to our Database. It is used to do query, write PL/SQL, execute and fine-tune our database queries for better performance and optimization.
Pros
Database query execution
Connection to various database
Multiple DB connections
Cons
DB query optimization
DB query auto formation
Improve explain plan
Likelihood to Recommend
Toad is very popular and widely used across organizations and teams. It is useful to connect to the individual database schema or if you have multiple database schemas. It can be useful when you need to connect to your development, test and production database simultaneously. The user interface is very friendly and easy to use for the newbie to advance database programmer.
Toad for Oracle is being used in our department here at Experian for querying the database and troubleshooting issues with the Oracle application which are reported to us.
Toad is a crucial tool for our department as we have limited front-end access, and therefore we have a controlled platform to query tables/packages where differing levels of rights and access is granted for HR/Finance respectively.
Pros
Quick querying of data and debugging of issues which is particularly made easier with the stored procedures function and has a very friendly user-interface.
The use of a stored TNSnames file for accessing the different environments makes it very simple to connect to different databases.
Creating and editing packages is very simple and allows you to toggle different views of the package which is very handy when they are of such a large size.
Cons
Version control on stored procedures - currently not something which is available
To allow scheduled reporting remotely without the need to be physically logged into the software
Likelihood to Recommend
Toad is well suited to our data-centric organization as we have segregation of duties for HR/Finance and we have restricted access to particular tables. Rights given to perform write functions to DEV and Read-Only for UAT/PROD makes this a very secure tool for our business to prevent data corruption.
Toad for Oracle makes things VERY easy for the developer. I like the PL/SQL templates within the product. I also like how easy it is to add your own shortcuts to customize the coding experience to your needs.
In my book: Toad for Oracle Unleashed, chapter 10 is 'Toad as a SQL Tuning Tool'. The Toad team has made performance tuning of SQL very easy.
I use Toad for light development, as a data query tool, and as a SQL performance tuning tool.
Pros
SQL Performance Tuning. The Toad team has done a great job with explain plans...and DBMS_XPLAN displays as well. They have also included 'advanced' explain plan features that one would have to use SQL*Plus to get otherwise. The Toad Team has a great Trace File Browser that takes you right to the poorly performing SQL.
Toad for data analysis. Toad is a great query tool. If you don't know SQL, Toad has this great Query Builder that is a drag/drop operation that will create simple to advanced SQL just using your mouse. You can then export to a nice report writer and Excel. Most export to Excel.
Oracle code development. Toad is simply the best with its templates, ability to condense and expand code...and allows you to add your own short cuts to help customize Toad to your programming needs.
Cons
I've wanted the Toad Team to make some of the more advanced features available on more affordable packages. Right now, I can't think of any functionality that is missing that I turn to another tool for.
Toad now does ( ) matching...this is something I used to have to use the vi editor for...but now Toad covers it. Toad also covers brace and bracket matching.
The Toad Team did add my QBLOCK_NAME stuff...that is super helpful when performance tuning SQL that contains sub queries. We worked together on this and now I can use Toad for this type of tuning as well.
Likelihood to Recommend
I know of many companies that use Toad as a data analysis tool. Toad has a great following and I know people who switched jobs and now do not have Toad...and REALLY miss it.
Toad is a good development GUI. Toad is great for data retrieval, even for the novice... Toad is a great SQL tuning tool.
Many platforms [designed] to manage a database are intended to simplify the management of databases. Although generally in large companies their DBA is responsible for supporting these issues, many companies still look positively on using these tools to control their operations’ databases. And not only in positions such as a DBA, but in positions where software development database management tools are mostly welcomed for the simplicity, ease of use and speed they offer in their work.
Of these existing tools for Oracle SQL - we find Toad as the most versatile among them in terms of simplicity, ease and speed alternative.
Pros
It is simple to use. If you are migrating languages you'll find many similarities with respect to SQL Server Development Studio or MySQL Workbench.
Its performance is good. You will not be [waiting] long before you run a query or [have to] get used to long waits.
The learning curve is almost direct.
Cons
If you already use Oracle SQL Developer, you could expect some delays or a learning curve in finding all the options.
You need to get a license.
It can be somewhat heavy compared to tools among other areas.
Likelihood to Recommend
If you need to rely on a tool [to build a database], Toad is recommended. Oracle SQL Developer is better for when you go to live [a]long with Oracle. According procurement policies software, Toad may not be the most advisable option because you must purchase a license.
Toad is being used in my whole organization for daily Database activities and module development like Packages, Procedures, Table creation, Triggers, Functions and more. It helps us in developing SQL scripts and managing our organization's database. The business problems which we solve using Toad are Data cleanup, everyday monitoring the database and doing modifications in the database, if needed.
Pros
It provides excellent platform for writing database queries and executing them and at the same time managing the complete database. It is beneficial for everyone from DBA to SQL developers.
Its main strengths include in the functionalities such as Script execution, Generating ER diagrams, Evaluating Queries and Query plans, Generating Schema Doc, Importing & Exporting results of queries and Reverse Engineering.
It has the capability to show the statistics related to time taken by a query to execute completely and finally how many records have been retrieved from that query.
It allows me to view different type of packages present inside any database scheme easily and then allowing export of queries into csv or excel files.
Cons
Since it doesn't offer a very large buffer size, it will not be beneficial when you need to retrieve millions of rows from a query. So, it is not beneficial for executing very large queries.
It has a slow performance when you execute a query which will retrieve large number of rows and thus you could only process a fixed amount of information at a particular time using Toad.
It doesn't provide any script history to view your previous queries which you have executed in Toad. I would like this feature to be added in Toad.
Likelihood to Recommend
I would say Toad is an excellent database management tool for analyzing and maintaining the database of an organization. It can be termed as the first preferred choice as the Query Builder providing graphical representation for your queries. It is well suited for companies that don't have a very large database, i.e approximately not more than 1 million records are processed every day.
Toad for Oracle is being used by a department. We use it to monitor database activity, create database jobs, PL/SQL development, SQL tuning, and for the creation and maintaining of functions, procedures, packages, and views. We also use it to create new tables, sequences, and to alter existing tables. I have used it to debug but find it was crashing at times during that process so I debug several other ways instead.
Pros
Very easy to get an explain plan on a query that is running a bit slow.
You have the ability to change the layout of Toad for Oracle to be more appealing to you as a user. For example, In schema browser you can set the selections in a drop down view, a tab view, or another view.
You are able to have multiple session schemas open at the same time.
Cons
I think more understandable explain plans would help some users be better able to correct issues of slow queries. This would be more appealing to less experienced users.
Trying to set up the options for Toad for Oracle is rather cumbersome. It is sometimes difficult to find the options that you are seeking. I think the options could be laid out in a better way.
Random crashing of Toad for Oracle when you stop execution of a query.
Likelihood to Recommend
Do you do database monitoring? Do you develop PL/SQL?
VU
Verified User
Employee in Information Technology (Information Services company, 1-10 employees)
