Interested to Buy Any Domain ? << Click Here >> for more details...
Can you define an Index if the table size less than 10
PAGES?
- 1 Answers
- 6316 Views
- IBM, I also Faced
- E-Mail Answers
Answer / s
You do not want to define an index on such a small table
because, its an overhead to maintain the index and
tablespace scan will only result in 1 I/O.
| Is This Answer Correct ? | 6 Yes | 2 No |
How would you find out the total number of rows in a db2 table?
Mention the location where the output received from explain statement is stored.
where can we use index and subscript ? with example ?
How is a typical DB2 batch program executed ?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What do you do to keep the cursor from closing after a commit?
Define predicate?
What is the result of open cursor statement?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
Is db2 a programming language?
Comment whether the cursor is closed during commit or not.
COBOL 
