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 cursor stability in db2?

796


What is db2 stogroup?

666


What is rct?

744


What kind of database is db2?

563


How to resolve deadlock issue

17922






How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1698


Who uses db2?

565


What is the use of commit in db2?

623


What do you mean by storage group (stogroup)?

574


can all users have the privilage to use the sql statement select * (dml)?

629


What is a buffer in memory?

587


What types of tables are there in the db2 database?

543


How to check last update on table in db2?

622


What is db2 optimizer?

763


What is the picture clause of null indicator variable?

682