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's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


What is the picture clause of the null indicator variable?

6 Answers  


What types of tables are there in the db2 database?

0 Answers  


What is dbrm library?

0 Answers  


how to check the table is empty or not?

3 Answers   IBM,






cursor with hold explain ?

1 Answers   Verizon,


How to resolve -502 sql code in DB2?

2 Answers   Cap Gemini,


How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,


suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,


Give a brief description of db2 isolation levels?

0 Answers  


What is multi row fetch in db2?

0 Answers  


How would you print the output of an SQL statement from SPUFI?

2 Answers  


Categories