Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 4 Answers
- 8898 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sachin borase
Optimized access path means:
When we are runnign any query database make the
path to db2 for fetching the required data called as
optimized acess path.for creating optimized access path
db2 uses db2 catlg.
expalain?
if put EXPLAIN(yes) then optimized path will sotred
whatever query you written in the program in the
table owner.plan_table
How to acess:
if you acess the owner.plan_table
it will have the below imp coloumns.
1.program name
2.latest timestamp
3.indexused
4.and more details
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
When do you specify the isolation level?
What is runstats db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Explain correlated sub-queries.
What is the default page size of buffer pools?
What is a dbrm in db2?
List out the buffer pools in db2
What is the max length of sqlca?
What is nvl in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
can we view the access paths created by dbrm ? how ? thx
How do you stop a db2 database in linux?
What is null indicator in cobol db2?
What is a db2 tablespace?
