Queries and Deletions

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

• Structuring Queries
  Improving query structures can make your queries run faster.
• Generating Query Plans
  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 the SET ANY PUBLIC OPTION system privilege can give certain users’ queries priority over others, or change processing algorithms to influence the speed of query processing.
• Optimizing Delete Operations
  SAP Sybase IQ chooses the best algorithm to process delete operations on columns with HG and WD indexes.