SQL Index ManagerRedgate Software
|
||||||
Related Products
|
||||||
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
SQL Index Manager lets you quickly and easily find out the status of your indexes and discover which databases need maintenance. You can do maintenance through the UI, or generate a T-SQL script to run in SQL Server Management Studio. Detect index fragmentation to get a full report on indexes across your databases, including the severity of fragmentation and the reasons for it. Fix fragmentation by choosing which indexes to fix based on fragmentation severity – SQL Index Manager will perform the operation for you. Reorganize or rebuild by setting which action to take, based on customizable rebuild and reorganization thresholds, and rebuild indexes online with SQL Server Enterprise Edition. Analyze over time by exporting the results of your analysis to track and report on fragmentation. Generate scripts by automatically generating T-SQL scripts to fix fragmentation. Start rebuilding or reorganizing selected indexes with a single click.
|
|||||
Platforms Supported
Windows
Not Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
Platforms Supported
Windows
Not Supported
Mac
Not Supported
Linux
Not Supported
Cloud
Supported
On-Premises
Not Supported
iPhone
Not Supported
iPad
Not Supported
Android
Not Supported
Chromebook
Not Supported
|
|||||
Audience
Individuals looking for query optimization in database industry, advanced SQL rewrite optimization, and sophisticate index recommendation capabilities for slow queries
|
Audience
Developers looking to analyze, manage, and fix database index fragmentation
|
|||||
Support
Phone Support
Not Supported
24/7 Live Support
Not Supported
Online
Supported
|
Support
Phone Support
Not Supported
24/7 Live Support
Not Supported
Online
Not Supported
|
|||||
API
Offers API
Supported
|
API
Offers API
Not Supported
|
|||||
Screenshots and Videos |
Screenshots and Videos |
|||||
Pricing
No information available.
Free Version
Supported
Free Trial
Not Supported
|
Pricing
$242 per user
Free Version
Not Supported
Free Trial
Supported
|
|||||
Reviews/
|
Reviews/
|
|||||
Pros & Cons from Real UsersPros
Cons
|
||||||
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Not Supported
|
Training
Documentation
Supported
Webinars
Not Supported
Live Online
Not Supported
In Person
Not Supported
|
|||||
Company InformationPawSQL
Founded: 2024
China
www.pawsql.com
|
Company InformationRedgate Software
Founded: 1999
United Kingdom
www.red-gate.com/products/sql-index-manager/index
|
|||||
Alternatives |
Alternatives |
|||||
|
|
||||||
|
|
||||||
|
|
||||||
Categories |
Categories |
|||||
Integrations
DataGrip
Supported
MariaDB
Supported
MySQL
Supported
Oracle Database
Supported
PostgreSQL
Supported
SQL
Not Supported
SQL Server
Not Supported
SQL Server Management Studio (SSMS)
Not Supported
|
Integrations
DataGrip
Not Supported
MariaDB
Not Supported
MySQL
Not Supported
Oracle Database
Not Supported
PostgreSQL
Not Supported
SQL
Supported
SQL Server
Supported
SQL Server Management Studio (SSMS)
Supported
|
|||||
|
|
|