Naresh Adurty

Sybase ASE 15 supports the use of many optimization techniques and tools. The use of these tools requires an expert level of understanding since improper application of query optimization tools can degrade performance for ASE as a whole. In this excerpt, the following optimization techniques are discussed from a standpoint of how to recognize problems resulting from the improper application of optimization strategies in ASE 15. Optimization Goal Performance Analysis Use optimization goals with caution. When optimization goals are altered by the database administrator, it may be necessary to periodically benchmark queries where optimization goals are employed. This benchmarking is necessary since the optimization goals instruct a query to perform optimization based upon known database usage patterns of OLTP, DSS, or mixed-use systems as an example. Over time, the usag... (more)