QueryTree

QueryTree

D4 Software
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company

About

PawSQL integrates the best practices of query optimization in database industry, provides advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries. Based on the professional PawSQL optimization engine (used by more than 10,000 database practitioners around the world), it provides rich SQL optimization suggestions and intelligent index recommendations. PawSQL provides a comprehensive and balanced audit rule set for multiple databases such as MySQL, PostgreSQL, openGauss, Oracle, etc., providing enterprises with a consistent audit experience no matter how diverse their database environment is. Rule-based SQL review, covering potential correctness and performance optimization issues. Rich rewrite optimization, recommending semantically equivalent but more efficient SQL queries. Cost-based verification ensures that new solutions based on SQL rewrite and index recommendation have better performance. Intelligent index recommendation.

About

Enjoy the highest performance and unlimited possibilities when working with PostgreSQL. PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi and C++Builder including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster, and cleaner PostgreSQL database applications without deploying any additional libraries. PgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to PostgreSQL. It provides direct access to PostgreSQL without PostgreSQL Client. PgDAC allows developers to optimize their database applications and harness the full capabilities of PostgreSQL.

About

QueryTree makes it easy to build and share reports on your software's databases. QueryTree is an open-source ad hoc reporting and visualization solution for your app. Download from Github, run it from Source, Binaries or using Docker, then connect it to any Microsoft SQL Server, MySQL or PostgreSQL database, and you’re good to go. As your app’s missing report screen, QueryTree enables technical and non-technical users alike can easily select, filter, group, aggregate and visualize data from any table in any database. Users can export their results, share reports with their team, and set up schedule emails to keep everyone updated. Give your users our intuitive and user-friendly report builder to explore, select, and summarize their data. Generate useful interactive charts that visually summarize what's really going on without writing a single line of code. Securely connect your MySQL, PostgreSQL, or Microsoft SQL Server database in just a few minutes.

About

SQL Query Tuner helps database administrators to tune and profile SQL code for SQL Server. Unlike its competition, it provides automated SQL tuning and performance optimization suggestions with color-coded index analysis, database profiling of wait-time analysis for a single stored routine or an entire data source, SQL stress load testing to simulate a production environment with parallel users and executions over a specific period of time or execution cycle, and review of SQL execution and performance costs using explain plans.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Individuals looking for query optimization in database industry, advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries

Audience

Programmers seeking a solution to develop lightweight, faster, and cleaner PostgreSQL database applications

Audience

Companies searching for a solution to build and share reports on their software's databases

Audience

database administrators for Microsoft SQL Server

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version
Free Trial

Pricing

$199.95 per year
Free Version
Free Trial

Pricing

$29 per month
Free Version
Free Trial

Pricing

$400 per instance
Free Version
Free Trial

Reviews/Ratings

Overall 5.0 / 5
ease 5.0 / 5
features 5.0 / 5
design 4.0 / 5
support 3.0 / 5

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

PawSQL
Founded: 2024
China
www.pawsql.com

Company Information

Devart
Founded: 1997
Czech Republic
www.devart.com/pgdac/

Company Information

D4 Software
United Kingdom
querytreeapp.com/

Company Information

IDERA, an Idera, Inc. company
Founded: 2004
United States of America
www.idera.com/productssolutions/sqlserver/sql-query-tuner

Alternatives

Alternatives

Alternatives

DBHawk

DBHawk

Datasparc

Alternatives

DB Optimizer

DB Optimizer

IDERA, an Idera, Inc. company
EMS DB Extract

EMS DB Extract

EMS Software
SQL Diagnostic Manager for SQL Server

SQL Diagnostic Manager for SQL Server

IDERA, an Idera, Inc. company
SQL Query Tuner

SQL Query Tuner

IDERA, an Idera, Inc. company
Luna Modeler

Luna Modeler

Ideamerit
DB PowerStudio

DB PowerStudio

IDERA, an Idera, Inc. company
PostgreSQL

PostgreSQL

PostgreSQL Global Development Group
TablePlus

TablePlus

TablePlus InC
SQL Sentry

SQL Sentry

SolarWinds

Categories

Categories

Categories

Categories

Reporting Features

Customizable Dashboard
Data Source Connectors
Drag & Drop
Drill Down
Email Reports
Financial Reports
Forecasting
Marketing Reports
OLAP
Report Export
Sales Reports
Scheduled / Automated Reports

Database Features

Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization

Database Monitoring Features

Anomaly Detection
Autodiscovery
Capacity Planning
Dashboard
Dependency Tracking
Historical Trend Analysis
Multitenancy
Notifications / Alerts
Performance Monitoring
Permissions / Access Controls
Predictive Analytics
Prioritization
Query Analysis
Resource Optimization
Troubleshooting

SQL Server Features

CPU Monitoring
Credential Management
Database Servers
Deployment Testing
Docker Compatible Containers
Event Logs
History Tracking
Patch Management
Scheduling
Supports Database Clones
User Activity Monitoring
Virtual Machine Monitoring

Integrations

ADO.NET Data Providers
Amazon EC2
Amazon RDS
Azure SQL Database
Azure Virtual Machines
C++Builder
Collate
DataGrip
Delphi
Google Cloud Platform
MariaDB
Microsoft 365
Microsoft Excel
MySQL
Oracle Cloud Infrastructure
Oracle Database
Pascal
PostgreSQL
SQL Server
Visual Studio

Integrations

ADO.NET Data Providers
Amazon EC2
Amazon RDS
Azure SQL Database
Azure Virtual Machines
C++Builder
Collate
DataGrip
Delphi
Google Cloud Platform
MariaDB
Microsoft 365
Microsoft Excel
MySQL
Oracle Cloud Infrastructure
Oracle Database
Pascal
PostgreSQL
SQL Server
Visual Studio

Integrations

ADO.NET Data Providers
Amazon EC2
Amazon RDS
Azure SQL Database
Azure Virtual Machines
C++Builder
Collate
DataGrip
Delphi
Google Cloud Platform
MariaDB
Microsoft 365
Microsoft Excel
MySQL
Oracle Cloud Infrastructure
Oracle Database
Pascal
PostgreSQL
SQL Server
Visual Studio

Integrations

ADO.NET Data Providers
Amazon EC2
Amazon RDS
Azure SQL Database
Azure Virtual Machines
C++Builder
Collate
DataGrip
Delphi
Google Cloud Platform
MariaDB
Microsoft 365
Microsoft Excel
MySQL
Oracle Cloud Infrastructure
Oracle Database
Pascal
PostgreSQL
SQL Server
Visual Studio
Claim PawSQL and update features and information
Claim PawSQL and update features and information
Claim PostgreSQL Data Access Components and update features and information
Claim PostgreSQL Data Access Components and update features and information
Claim QueryTree and update features and information
Claim QueryTree and update features and information
Claim SQL Query Tuner and update features and information
Claim SQL Query Tuner and update features and information