Toad Review

Best tool to work with Oracle

Valuable Features:

  1. Horizontal layout for each connected database connection
  2. Easy way to generate statements for select,insert and update
  3. Easily identify the locks on the table and processes running on the database and their source information
  4. It is easy to Explain plan
  5. It is easy to optimize the query using optimizer
  6. Table import and export are easy
  7. Formatting of sql also makes it easy to read

Room for Improvement:

  1. Toad crashes sometimes and it will lose all the saved database information
  2. We cannot the execute SQL, offline easily (If you are creating a MV and if you shut down your laptop it won't create it)

Use of Solution:

I have used it for more than 5 years

Previous Solutions:

I have worked with sql developer before and it not easy to work with

Initial Setup:

It is straight forward if you have Tnsnames entries located correctly

Implementation Team:

In house

Other Solutions Considered:

Sql developer
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Add a Comment
Sign Up with Email