Can you define an Index if the table size less than 10
PAGES?



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

Post New Answer

More DB2 Interview Questions

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.

3 Answers   Wipro,


Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?

2 Answers  


what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  


What does sqlcabc has?

0 Answers  


How will fetch last 5 rows from table in db2

6 Answers  


How to solved 818 error

4 Answers   Keane India Ltd, Wipro,


How to retrieve rows from a db2 table in embedded sql?

0 Answers  


Explain the EXPLAIN statement?

1 Answers  


What is an intent lock?

3 Answers  


In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


Explain db2.

0 Answers  


Categories