Increase the performance of custom real-time market data analysis applications by adding the appropriate indexes to the market-data tables and tuning the syntax of select queries.
However, strive to maintain a careful balance, because adding an excessive number of indexes may negatively impact message load performance. See Adaptive Server Enterprise Performance and Tuning Series: Query Processing and Abstract Plans.