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
- 8892 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sdexcellent@yahoo.co.in
EXPLAIN is used to display the access path as determined by
the optimizer for a SQL statement.
It can be used in SPUFI (for single SQL statement ) or in
BIND step (for embedded SQL ).
plan table should be created under your authid.if its there
then only EXPLAIN can be used in SPUFI.
Output of EXPLAIN can be stored in userid.plantable
in spufi u ve to write the query with ?
select billtn,lpic from xxxx where lpic > ?
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Before you give the explain statement, what are the prerogatives?
What are foreign keys in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is null indicator in cobol db2?
How does coalesce work?
Is db2 free?
Can we delete records from view?
How do I delete a table in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What are db2 tables?
What does a deadlock mean in DB2?
What is ibm db2 client?
What is the use of db2 optimizer?
What are the benefits of using the db2 database?
Define db2.
