Where is the output of EXPLAIN stored?

Answer Posted / mainframe.rahulz

EXPLAIN stores output in PLAN_TABLE

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dpf in db2?

752


What is the function of logging in the db2 database?

730


What is database alias db2?

692


What is a db2 schema?

862


What is the maximum size of a char data type in db2?

672






What is rct?

846


Define sqlca.

729


How can the duplicate values be eliminated from db2 select?

729


What are the prerogatives?

701


List down the types of triggers in the db2 database?

684


What is the difference between cursor stability and repeatable read isolation levels?

777


What is db2 command?

669


What is the use of db2 optimizer?

694


What is bind plan?

701


What is the picture clause of null indicator variable?

772