Business Services Industry
PLATINUM technology announces Plan Analyzer for Oracle; tool automates SQL statement tuning to maximize database performance
Business Wire, Jan 22, 1996
OAKBROOK TERRACE, Ill.--(BUSINESS WIRE)--Jan. 22, 1996-- PLATINUM technology, inc., today announced availability of PLATINUM Plan Analyzer for Oracle, a Windows-based tool that automates the task of tuning SQL statements for Oracle databases. Plan Analyzer eliminates the need to manually create, display, interpret, and test SQL optimization plans to increase database and application performance.
"SQL optimization plans can impact client/server application performance more than any other factor," said Scott Kane, senior vice president of database management for PLATINUM. "But optimizing SQL statements has traditionally been a laborious and often neglected task because it has required a high-level of expertise to interpret the optimization plans. Plan Analyzer automates SQL optimization planning, allowing both novice and expert Oracle administrators and developers to efficiently optimize SQL statements and enjoy improved database and application performance."
How Plan Analyzer Works
Plan Analyzer helps users determine which SQL optimization plan is fastest and consumes the least resources. Using simple point-and-click commands, Oracle administrators and developers can use the standard default optimization methods for each SQL statement: rule-based, cost-based (all rows and first row), and a customized plan with Oracle database hints. Results are provided in a graphical summary, and an explanation of each optimization plan is provided in plain English.
The database tool contains a SQL capture facility that allows users to trap and optimize the SQL code contained in application development tools like Microsoft Corp.'s Visual Basic and Powersoft Inc.'s PowerBuilder. In addition, Plan Analyzer lets Oracle administrators and developers save all SQL optimization plans and performance statistics in a row-level ownership repository, allowing retrieval and verification of optimization plans. The database tool also enables developers to readily implement array operations, which dramatically speed up frequently-used insert, delete, and update operations.
PLATINUM's Product Integration Strategy
Plan Analyzer is part of PLATINUM's product strategy to bring best-of-breed data and systems management to the open enterprise environment -- the networked, heterogeneous computing environment that includes MVS-, UNIX-, and Windows-based platforms and may contain VMS, AS/400, and OS/2 systems.
Availability, Pricing and Platform Support
Plan Analyzer is available immediately. Starting list price is $1,995 per single user license. The database tool is compatible with Oracle Versions 6 and 7, and runs on Windows 3.0 and above, Windows 95, and Windows NT. PLATINUM plans to add Motif support to Plan Analyzer for Oracle in the first quarter of 1996. For pricing information call PLATINUM technology at 1-800-442-6861 or 1-708-620-5000; or send email to info@platinum.com.
PLATINUM technology, inc., delivers the payoff on information technology (IT) investments by providing tools that enable organizations to efficiently manage next-generation computing solutions while leveraging existing and legacy systems. The company provides application development, business intelligence, database administration, data warehousing, and systems management software solutions for the Open Enterprise Environment (OEE )-- the networked computing environment that incorporates mainframe, desktop, and open systems.
Additional information about PLATINUM technology, inc. is available via the World Wide Web at http://www.platinum.com.
Note to Editors: In some systems, the ``at symbol'' in the e-mail addresses below could become garbled. They should be understood to appear between ``dobinski'' and ``platinum.com'', between ``peterg'' and ``ca.cbpr.com'' and between ``info'' and ``platinum.com''. There is also a double forward slash after ``http:'' in the URL address below. That symbol may not appear properly in some systems.
CONTACT: PLATINUM technology, inc., Oakbrook
Jan Scharlow/Rich Dobinski, 708/620-5000, ext. 1990
or
Copithorne & Bellows
David Kitchen/Peter Gorman, 617/252-0606, ext. 242
Most Recent Business Articles
- Multiple criteria evaluation and optimization of transportation systems
- Multi-criteria analysis procedure for sustainable mobility evaluation in urban areas
- A two-leveled multi-objective symbiotic evolutionary algorithm for the hub and spoke location problem
- Multi-criteria analysis for evaluating the impacts of intelligent speed adaptation
- The development of Taiwan arterial traffic-adaptive signal control system and its field test: a Taiwan experience
Most Recent Business Publications
Most Popular Business Articles
- 7 tips for effective listening: productive listening does not occur naturally. It requires hard work and practice - Back To Basics - effective listening is a crucial skill for internal auditors
- FAS 109: a primer for non-accountants - Financial Accounting Standards Board's "Statement 109: Accounting for Income Taxes"
- LIFO vs. FIFO: a return to the basics
- Design a commission plan that drives sales - Sales Commissions
- Too Young to Rent a Car? - 25-years-old the minimum age for car renting - Brief Article
Most Popular Business Publications
Content provided in partnership with
