While many of the performance improvement changes are built into the internals of the database server, a new Index Consultant provides administrators with an easy-to-use way of optimizing performance by guiding them through the selection of appropriate indexes. Innovative new algorithms make many queries run in a fraction of the time of previous releases. Query processing has also taken another big step forward. Customers already run Adaptive Server Anywhere with several hundred simultaneous users, and this release looks to raise the bar on the scale that can be handled. A redesign of the cache management system makes for much-improved concurrency at high numbers of users. Scalability and performance In this release, Adaptive Server Anywhere has taken more major strides in scalability and performance. Here are some of the highlights in this release of the Adaptive Server Anywhere database. Welcome to SQL Anywhere Studio Version 9 Adaptive Server Anywhere highlights
