-
Performance Tuning
What is the role of page size and data and cache memory in increasing the performance of the query. What other external factors can cause performance issues?
-
Query Performance Tuning
What parameters would you look for while trying to optimise your query? How is the cost of a query measured
-
Query Plan
How does Sybase system decide on which plan to use for a query? Can you force a plan to be used by the Sybase system