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
- 6207 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 can record locking be achieved in those DB2 versions which do not support it?
how to copy the host variables from ps file into cobol program other than include statement
When is the results table for the query in a DECLARE CURSOR statement created?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
What language is db2 written in?
What is a Resource Control Table(RCT)? Describe its characteristics.
What is the use of reorg in db2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
How to find last record before record through SQLRPGLE?
How would one remove old reorg information from the DB2 catalog?
Explain what a plan is?
What is a correlated sub query?
COBOL 
