What is the impact on systems performance when you run Data Access Studio?
DAS does the following to minimize any system performance degradation: • Generates the highest performing query possible. • Provides an “index assistant” which helps the user identify which columns will generate the fastest query. • Allows user to hide unnecessary table columns and save this as a layout. DAS will only bring back the visible columns. This results in reduced network traffic, reduced database utilization, and increased speed. • Allows an administrator to control which groups can do ad hoc queries versus published queries. • Consumes no JDE enterprise server resources.
