Can you define an Index if the table size less than 10
PAGES?
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 |
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What does sqlcabc has?
How will fetch last 5 rows from table in db2
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
How to retrieve rows from a db2 table in embedded sql?
Explain the EXPLAIN statement?
What is an intent lock?
In which column of which DB2 catalog would you find the length of the rows for all tables?
Explain db2.