Small Correction: With explain(Yes) option, Access path or optimizer's

what is the steps followed in EXPLAIN Process or EXPLAIN
command. (Explain is for identifying the optimized access
path but how or what is the steps for doing the EXPLAIN)

Question Posted / bob

4 Answers
8723 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / bob

Small Correction: With explain(Yes) option, Access path or optimizer's strategy/information will be stored in package_owner.plan_table

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How is deadlock resolved?

1081

What is the difference between drop table and delete table?

1117

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

1114

What is concurrency?

1150

Explain the benefits you can get from mainframe connect?

910

How can you count the number of rows from a table tab?

1040

How would you find out the total number of rows in a db2 table?

988

When the like statement is used?

1156

what is diffrence b/w file-aid tool and file-aid utility???

4809

What is the reason behind not using select * in embedded sql programs?

1044

How does coalesce work?

959

How to find the number of rows in db2 tables?

996

How do I import a csv file into db2?

937

What is a trigger in the db2 database?

1014

What are the 2 sqlcodes that are returned?

1129