Optimizing Queries and Deletions

Recommendations to help you plan, structure, and control your queries.

• Tips for Structuring Queries
  Improving query structures can make your queries run faster.
• Planning Queries
  Generating a query plan can help you understand the execution plan developed by the optimizer.
• Controlling Query Processing
  Any user can set limits on the amount of time spent processing a particular query. Users with DBA privileges can give certain users’ queries priority over others, or change processing algorithms to influence the speed of query processing.
• Optimizing Delete Operations
  Sybase IQ chooses the best algorithm to process delete operations on columns with HG and WD indexes.