You can increase the performance of custom historical market data analysis applications by adding the appropriate indexes to the market data tables and tweaking the syntax of select queries.
However, strive to maintain a careful balance, because adding an excessive number of indexes may adversely affect the message load performance. See Sybase IQ Performance and Tuning Guide.