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 |
what are the SQL codes u freequently got?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
What is blu acceleration in db2?
What does db2 mean?
How can you do the explain of a dynamic sql statement?
How is the SUBSTR keyword used in sql?
what are extents?
What is the connection string to connect to the DB2 Database ?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
Where do you specify them?
What will the DB2 optimizer do?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?