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 SPUFI?

4 Answers  


How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  


What is the command used by TSO users to invoke DB2?

2 Answers   IBM,


What is ALTER ?

3 Answers  


which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  


I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,


What are types of indexes?

0 Answers  


What is commit in db2?

0 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


What is null indicator in db2?

0 Answers  


How can you count the number of rows from a table tab?

0 Answers  


Mention the location where the output received from explain statement is stored.

0 Answers  


Categories