explanatory vs. Pre-compiled1, the traditional database, stored procedures have comp process, IQ does not do. 2,!!! Stored procedure performance throughput is halved compared to direct queries. 3, within the IQ, multiple statements will be analyzed and converted into stored procedures to execute. So the statement executes more than once, and the statement executes less directly. 4. Using the indexSimplified conditionsSelect algorithm Join groupNumber of rowsCPUDISTINCT Record Countand so on, decided the grammar choice. 5.Query Plan switch:query_plan= ' on ',only leaf nodes have condition executionSet temporary OPTION Query_plan = ' on ';set temporary OPTION query_detail= ' on ';Set temporary OPTION query_plan_after_run = ' on ';Set temporary OPTION query_plan_as_html = ' on ';Set temporary OPTION query_plan_as_html_directory = ' h:/sybase/t1 ';Set temporary OPTION query_timing = ' on ';Set temporary OPTION index_advisor = ' on ';
From for notes (Wiz)
SAP Sybase Training Note 4-Tips for using &&query Plan
