What is explain plan in db2?
No Answer is Posted For this Question
Be the First to Post Answer
What is a result table?
What is database manager in db2?
What is image copy in db2?
Explain db2.
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How do you select a row using indexes in db2?
What is the purpose of the WHENEVER statement?
What is lock escalation?
What are the uses of db2 optimizer?
What is syscat in db2?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
What is multi row fetch in db2?