Query processing and Abstract Plans
Answer –>
1. Parser
2. Normalization
3. Preprocessor
4. Optimizer
5. Code generator
6. (1) Procedural execution engine
6. (2) Query execution engine
Query –> At which level in Query Processor Modules we can determine if the statement may benefit from using the statement cache?
Answer –> Level 2 (Normalization)
Query –> What does Normalization infers while query parsing (Query Processor Modules) ?
Answer –> Normalization involves determining column and table names, transforming the query tree into conjugate normal form (CNF), and resolving datatypes.
Query –> Define “Query Plan” ?
Answer –> Query Plan consists of retrieval tactics and an ordered set of execution steps, which retrieve the data needed by the query.
Courtesy: sybooks
Check the Sybase Wiki @ sybasewiki.com
Anurag has more than 6+ years of experience in Sybase Database Development .His Area of expertise includes Performance, Query Optimization, Cost Optimization, TSQL Development. He is also involved in Consultancy to Financial Firms for Database Implementation and Maintenance. He has supported many Global Financial firms.