What do you need to do before you do EXPLAIN?
Answer / s
Create the Plan_table to holds the results of the explain.
| Is This Answer Correct ? | 5 Yes | 0 No |
what is the difference between join and union?
why we go for SPUFI for creating tables or for sql queries?
What is meant by a unit of recovery?
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
What are data types?
What is commit in db2?
How to connect to db2 database from windows command line?
How to compare data between two tables in db2?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What are column-name qualifiers used?
What is dynamic SQL?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?