Where is the output of EXPLAIN stored?

Answer Posted / s

The Explains writes the output to the 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 a storage group (stogroup)?

774


What is cascading rollback?

621


what is db2 restart?

1689


While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

1816


What are the 2 sqlcodes that are returned?

633






How do you concatenate the firstname and lastname from emp table to give a complete name?

599


What's The Percentage Free Space ?

766


What are the bind parameters ibm db2?

622


What is deadlock in db2?

577


What is the usage of open cursor command?

599


How to find the number of rows in a db2 table?

644


What is schema in db2?

572


What is db2 optimizer?

769


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2044


What is the physical storage length of date data type?

722