Usually, which is more important for DB2 system
performance - CPU processing or I/O access?
Answer / s
I/O is expensive as most the the CPU time is wasted doing
I/O's
| Is This Answer Correct ? | 2 Yes | 1 No |
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?
What is check constraint in db2?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
What happens to the PLAN if index used by it is dropped?
What does DSNDB07 database do?
What is db2?
can all users have the privilage to use the sql statement select * (dml)?
What is catalog database in db2?
What is query for your birthday date should be in hours,minute and seconds format?
What is node in db2?
What are the abend codes occour in ur latest PROJECT in DB2
Discuss about db2 bind?