You can make database-specific configurations in the Properties tab for a connection, in the Explain Plan category. This project create on sql and ole factory technology and have injection security, typed query. The databases use different techniques to manage their explain plan support. Use the menubar buttons to export and print. The graph can be exported to an image file or printed. The Graph View shows the plan as a graph.
#VERTICA DBVISUALIZER DRIVERS#
DbVisualizer utilizes the underlying JDBC drivers from each database vendor to integrate with and provide support for most major commercially available database engines. It runs on Windows, MacOS och Linux / Unix. I am not sure where to put the configuration file. DbVisualizer is a database management system tool that is independent of database vendors. The documentation says to configure the JAASConfigName property as verticajdbc.
#VERTICA DBVISUALIZER WINDOWS#
I need to connect to linux based vertica 7.1 with windows based dbvisualizer thru jdbc. The following screenshot shows the SQL in the editor at top and the corresponding explain plan as the result. How do I setup DBViaualizer to connect to vertica using Kerberos authentication RCasey. In the tree view, put the mouse pointer on the column header for a tooltip description what that column represents.
![vertica dbvisualizer vertica dbvisualizer](https://i.stack.imgur.com/29n6x.png)
What information is shown depends on the database you use. For databases more commonly used in the industry, they have added support for database specific features. DbVisualizer is tested with the major databases and JDBC drivers. It runs on all major OS and can connect to all commercially viable database engines. The explain plan results can easily be compared by pinning the tabs for different runs.ĭbVisualizer presents the plan either in a tree style format or in a graph, or in a simple text format. DbVisualizer is a universal database for administrators, developers, and analysts. The explain plan feature works much the same as executing SQLs to present result sets you may highlight statements, run a script or load from file. By examining this plan, you can find out if the database is picking the right indexes and joining your tables in the most efficient manner. Explain Plan executes your query and records the plan that the database devises to execute it.