Probe into the performance of SQL statements by providing visibility and insight as to how syntax, cardinality, index usage and data skew affect and vary performance over time in a variety of situations. View execution plans using a graphical and user-customizable display of the database’s internal processing order and priorities for queries. Sophisticated diagnostics help you pinpoint performance inefficiencies that result in poor space management, tracking key database metadata and performance metrics over time. Manage the performance of your databases with a built-in process monitor that helps you understand who is connected to your database along with each user’s current activity and session-related data. Manage Space, Data and Performance AnalyticsĬomprehensive tools help you manage space, data and performance to keep your databases optimized and available. Manage multiple Oracle-specific schema object types and SQL Server advanced object properties such as temporal tables, in-memory tables, and natively compiled triggers, procedures and functions. Reduce training requirements and streamline collaboration among different teams across the organization. Proactively manage all major relational database platforms (Microsoft SQL Server, Microsoft Azure SQL Database, Oracle Database, IBM Db2 LUW and z/OS, SAP Sybase ASE and IQ, MySQL, PostgreSQL, Pivotal Greenplum, Amazon Redshift, and Snowflake) from a single common graphical user interface. Manage Multiple Platforms with One Interface Protect data security with view, grant and revoke of permissions.Move schema and table data across different platforms with ease.
0 kommentar(er)
