Railways Optimizer merzt weak points in SQL out

The railways Optimizer of Embarcadero a SQL Profiling is and - Tuning IDE (Integrated development Environment). By inquiry statistics such as CCU, I/O and Waiting Times can analyze the software aimed specific SQL instructions and these for problems optimize. Railways Optimizer co-operate with all existing data base tools and prevent by thorough error tracing each loss.Further functions railways of the Optimizers: · graphic visualization of the Waiting time analysis: Hereby the places in the SQL code can be constituted, those for a slowing down of the data base are responsible (Bottlenecks)· Twisting Downs with hyperlink make entrance to detailed information about the activity for an SQL instruction possible· Explaining patterns help to understand and the expenditure to estimate be able the execution about SQL better · Error repair in real time: inefficient SQL remarks are recognized automatically and corrected (for Oracle)· Batches Tuning routines, whole SQL files and system stored by DML instructions, global AREA (Oracle)· Platform-independently: supports DB2, Oracle, SQL server and Sybase data bases“A golden rule with SQL is called: The output is only as good as the input. It does not give to work thus worse than with weak SQL code. The negative effect makes itself noticeably, “ in such a way in the achievement of entire application Thorsten Raab, chairman von Blue Harbors, a global SAP consulting firm. “Since we the railways Optimizer begin, can recognize we dataintensive or regular implemented inquiries better and optimize each problematic instruction. And definitely the efficiency of all data base-based applications increases. “Michael Swindell, Vice President for products of Embarcadero, promises further helpful products: „ with that we present first of several tools, which we plan in next time for our customers to railways Optimizer. In the focus it is located with the fact for us that the users can improve the performance of your applications on whole line: on the Clients, on the server, as well as in the data bases. Embarcadero supplies a complete portfolio of platform-independent Optimierungstools, as the enterprise combines the technologies of DatabaseGear and CodeGear. Thus we facilitate not only the work for the application developer, but also the data base professional and increase thereby the productivity of many enterprises.