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

How many types of page locks can be held in db2?

589


What is access path in db2?

562


What is the use of commit in db2?

628


Mention data types used in db2 ?

673


What is the physical storage length of the data types date, time, and timestamp?

604






How does cobol compile db2 program?

606


What is rct?

751


Comment whether the cursor is closed during commit or not.

668


How do I add a column to a table in db2?

616


Who uses db2?

572


What is the role of the data page in the db2 database?

585


What is db2 instance?

590


What is the function of logging in the db2 database?

638


What are the different types of base tables?

583


Name the various locking levels available?

632