What is DB2 and what is the use of DB2 Optimizer?
devquora
Posted On: Feb 22, 2018
DB2 is a huge relational database management system for the MVS (Multiple Virtual storages) operating systems, where the DB2 is a subsystem of MVS operating system.
Use of DB2 Optimizer:
The DB2 optimizer processes the SQL statements and helps to select the access path.
Use of DB2 Optimizer:
The DB2 optimizer processes the SQL statements and helps to select the access path.
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
DB2 Interview Questions
Mention data types used in DB2 ?
The data types used in DB2 are: SMALLINT DECIMAL CHAR FLOAT INTEGER VARCHAR DATE TIME ..
DB2 Interview Questions
What is Buffer pool and list some of them?
It is a reserved main storage which is to satisfy the buffer needs for one or more tablespaces or indexes. It is made u..
DB2 Interview Questions
Explain PACKAGE in DB2 and its advantages?
PACKAGE:They are units, which consists of many executable codes that are meant for SQL statements for one respective DB..